The Business Master (3rd Edition)

home *** CD-ROM | disk | FTP | other *** search

/ The Business Master (3rd Edition) / The Business Master (3rd Edition).iso / files / accoting / dayoap2 / dayovd.exe / DAYOAP.DOC < prev next >

Wrap

Text File | 1992-06-03 | 517.8 KB | 6,551 lines

╔════════════════════════════════════════════════════════════════════════════╗ ║ ║ ║ ║ ║ █▄██████████▒░ █████▒░ ██▒░ ██░ ███████████▒░ ║ ║ ███▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██░ ██▒░ ██▒░ ║ ║ ██▒░ ██▒░ █▒░ █▒░ ██▒░ ██░ ██▒░ ██▒░ ║ ║ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██░ ██▒░ ██▒░ ║ ║ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██░ ██▒░ ██▒░ ║ ║ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██░ ██▒░ ██▒░ ║ ║ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░██░ ██▒░ ██▒░ ║ ║ ██▒░ ██▒░ ███▀▀▀▀▀███▒░ ████▒░ ██▒░ ██▒░ ║ ║ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ║ ║ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ║ ║ ███▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ║ ║ █▀██████████▒░ ██▒░ ██▒░ ██▒░ ███████████▒░ ║ ║ ░░░░░░░░░░░ ░░░ ░░░ ░░░ ░░░░░░░░░░░░ ║ ║ ║ ║ ║ ║ ▀██▒░ ▀██▄███████▄ ║ ║ ████▒░ ██▒░ ██▒░ ║ ║ ██████▒░ ██▒░ ██▒░ ║ ║ ██▒░██▒░ ██▒░ ██▒░ ║ ║ ██▀ ▀██▒░ ██▄▄▄▄▄▄████▒░ ║ ║ ██▒░ ██▒░ ██▀███████▀ ║ ║ ▄██████████▄ ██▒ ║ ║ ██▒░ ██▒░ ██▒░ ║ ║ ██▒░ ██▒░ ██▒░ ║ ║ ▄██▒░ ██▒░ ▄██▒░ ║ ║ ║ ║ ║ ║ ║ ║ ACCOUNTS PAYABLE FOR THE DAYO MODULES ║ ║ ║ ║ ║ ║ Copyright (c) 1990-92, TJS LAB, PO Box 585366, Orlando, Florida 32858 ║ ║ ║ ║ ║ ║ ▓▓▓▓▓▓ ███████████▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▐█▌ ║ ║ ▀ ▓▓ ▀ ▓▓▓▓ ▀▀▀▀▀███████████████████████████▌ S ║ ║ ▓▓ ▓▓ ▄▓▓▓▄ ▀████▀▀ ▀████████████ O ║ ║ ▓▓ ▓▓ ▓▓ ▀▀ ███████████ F ║ ║ ▓▓ ▓▓ ▓▓ ▀▓▓▓▄ Specializing In ▐█████████▌ T ║ ║ ▀▓▓▓▀ ▓▓ MicroComputer ██████████ C W ║ ║ ▀▓▓▓▀ & LAN █████■████▌ O A ║ ║ Applications ▐███████████ N R ║ ║ ┌─┐ ┌─┐ ███████████▌ S E ║ ║ ▀▓▓ ▓ ▀▓▄▓▓▓▄ ┌╧─╧┐ ┌─┐ ┌╧─╧┐ ████▀ ▀███ U ║ ║ ▓▓ ▓▓▓ ▓▓ ▓▓ └───╜ ┌╧─╧┐ └───╜ ███ ██▌ L & ║ ║ ▓▓ ▄▓ ▓▄ ▓▓▓▓▓ ░█░ └───╜ ░█░ ███▄▄███ T ║ ║ ▓▓ ▓▓▓▓▓ ▓▓ ▓▓ █████ ░█░ █████ ▀█████▌ I ║ ║ ▓▓▓▓ ▄▓ ▓▄ ▓▀▓▓▓▀ █████ ▀▀▀█ N ║ ║ █ G ║ ║ PO BOX 585366, ORLANDO, FLORIDA 32858 ▄▄▄▄▀ ║ ║ ║ ╚════════════════════════════════════════════════════════════════════════════╝ DAYO AP, TJS LAB Orlando, Florida ■ SOFTWARE SUPPORT POLICY 1. TJS LAB does not support users of unregistered DAYO products with the exception of installation questions. 2. Support (included with registration) remains in effect for 3 Months after date of registration or upgrade. 3. Support is available through the following methods: - Phone/Voice Mail: (407) 291-3960/6987 - U.S. Mail: TJS LAB, PO Box 585366, Orlando, FL 32858-5366 - Compuserve Easyplex: 76367,1401 4. Any errors ("bugs or features') in the program will be corrected and the 'fix' sent promptly (via modem if possible). DAYO AP, TJS LAB Orlando, Florida Table of Contents Page Subject ──── ────────────────────────────────────────────────────────── 1......INTRODUCTION 2......COPYRIGHT/LICENSE 2......DISCLAIMER 2......REQUIREMENTS *** 2......SETUP 3......MAIN MENU 3...... PASSWORD/NAME 4......BROWSE 5...... BROWSE ACCOUNTS PAYABLE HEADERS 6...... BROWSE ACCOUNTS PAYABLE HEADERS - FULL SCREEN EDIT 6...... ADD A NEW AP RECORD/INVOICE 7...... BROWSE ACCOUNTS PAYABLE DETAIL 7...... BROWSE ACCOUNTS PAYABLE DETAIL - FULL SCREEN EDIT 8...... BROWSE VENDORS DATABASE 9...... BROWSE VENDORS DATABASE - FULL SCREEN EDIT 10...... BROWSE PURCHASE ORDER HEADERS 11...... BROWSE PURCHASE ORDER HEADERS - FULL SCREEN EDIT 12...... BROWSE PURCHASE ORDER DETAIL 13...... BROWSE PURCHASE ORDER DETAIL - FULL SCREEN EDIT 14...... BROWSE MAIN INVENTORY DATABASE 15...... BROWSE MAIN INVENTORY DATABASE - FULL SCREEN EDIT 16...... BROWSE MAIN INVENTORY DATABASE - WAREHOUSE TRANSFER 17...... BROWSE MAIN INVENTORY DATABASE - INVENTORY ADJUSTMENT 18...... BROWSE INVENTORY ADJUSTMENTS DATABASE 19...... BROWSE INVENTORY ADJUSTMENTS DATABASE - FULL SCREEN EDIT 20...... BROWSE WAREHOUSE INVENTORY DATABASE 21...... BROWSE WAREHOUSE INVENTORY DATABASE - FULL SCREEN EDIT 22...... BROWSE WAREHOUSE NAMES DATABASE 22...... BROWSE WAREHOUSE NAMES DATABASE - FULL SCREEN EDIT 23...... BROWSE RECEIVING DATABASE 24...... BROWSE RECEIVING DATABASE - FULL SCREEN EDIT 25...... BROWSE CHECKING ACCOUNTS DATABASE 26...... BROWSE CHECKING ACCOUNTS DATABASE - FULL SCREEN EDIT 27...... BROWSE CHECKS DATABASE 27...... BROWSE CHECKS DATABASE - FULL SCREEN EDIT 28...... BROWSE CHECK PRINTING FORMATS DATABASE 29...... BROWSE CHECKING ACCOUNT DEPOSITS 29...... BROWSE DEPOSITS DATABASE - FULL SCREEN EDIT 30......BATCH CHECKS 30...... PREPARE BATCH CHECKS 31...... SELECT CHECKING ACCOUNT NUMBER 32...... SELECT CHECK PRINTING FORMAT 33...... SELECT STARTING CHECK NUMBER 34...... BROWSE BATCH CHECKS 34...... BROWSE BATCH CHECKS - FULL SCREEN EDIT DAYO AP, TJS LAB Orlando, Florida Table of Contents Page Subject ──── ────────────────────────────────────────────────────────── 35...... PRINT BATCH CHECKS DRAFT 36...... PRINT BATCH CHECKS DRAFT 37...... BROWSE RECURRING CHECKS 37...... SCHEDULE CODES 38...... BROWSE RECURRING CHECKS - FULL SCREEN EDIT 39...... MARK/UNMARK FOR PRINTING 40...... RECURRING CHECK SUMMARY 40...... PRINT RECURRING CHECKS DRAFT 41...... PRINT & POST RECURRING CHECKS 41......HAND CHECKS 42...... SELECT ACCOUNT TYPE 42...... FINAL HAND CHECK EDIT 43...... APPLY TOWARDS MULTIPLE GL ACCOUNTS/ENTRIES 44...... APPLY TOWARDS AP PO/PAYABLE RECORDS 45......POSTING 45...... POST TO AP FILES 46...... EXPANDED EXPLANATION OF AP POSTING 47...... AP POSTING FLOWCHART 47...... VENDOR BALANCE DUE RESET/RECALCULATE 48......REPORTS 48...... REPORTS LIST 49...... ACCOUNTS PAYABLE SUMMARY 49...... PAYABLES SUMMARY (APH.DBF) 50...... DEPOSITS SUMMARY (DEPOSITS.DBF) 50...... CHECKS SUMMARY (CHECKS.DBF) 50...... ACCOUNT BALANCES (ACCOUNTS.DBF) 51...... MISCELLANEOUS EXPENSES SUMMARY (EXPENSES.DBF) 51...... PURCHASE ORDER HEADER REPORT 52...... PURCHASE ORDER DETAIL REPORT 52...... VENDORS REPORT 53...... VENDOR MAILING LABELS (BILLTO/SHIPTO) 54...... VENDOR FOLDER LABELS 54...... CHECKING ACCOUNTS REPORT 55...... AP CHECKS REPORTS 55...... CHECK FORMATS REPORT 56...... RECURRING CHECKS REPORT 56...... CHECK LISTING 57...... DEPOSITS REPORTS 58...... 1099 MISC FORMS 59...... MISCELLANEOUS EXPENSES REPORT 60...... EXPANDED INVENTORY REPORT 60...... INVENTORY ADJUSTMENTS 61...... RECEIVING REPORT 61...... UNCLEARED RECEIVERS REPORT 62...... UNCLEARED AP RECORDS REPORT DAYO AP, TJS LAB Orlando, Florida Table of Contents Page Subject ──── ────────────────────────────────────────────────────────── 62...... CLEARED RECEIVERS REPORT 63...... CLEARED AP RECORDS REPORT 63...... AP AGEING REPORT 64...... AP HEADER REPORT 66...... ACCOUNTS PAYABLE DETAIL REPORT 66...... REPRINT CHECKS 67...... CONFIGURATION STATUS REPORT 67...... EXAMPLE OF CONFIGURATION STATUS REPORT 68...... VIEW REPORTS ON SCREEN 69...... REPORT VIEWING SCREEN 70...... PRINTER DRIVER (SETUP) 70...... PRINTER DRIVER OPTIONS 71...... CHANGE DEFAULT PRINTER 72...... FULL SCREEN EDIT - F2 72...... PRINTER DRIVER DATABASE FIELD DEFINITIONS 73......CONFIGURATION 73...... CONFIGURATION LISTING 74...... COMPANY NAME, ADDRESS & TELEPHONE 74...... INVENTORY LOCATION/DIRECTORY 74...... POINT OF SALE (POS) DATABASES LOCATION/DIRECTORY 75...... CUSTOMER (AR) DATABASE LOCATION/DIRECTORY 75...... GENERAL LEDGER (GL) DATABASE LOCATION/DIRECTORY 75...... FEDERAL (TAX) IDENTIFICATION NUMBER (FIN) 75...... FORM 1099 DEFAULT TAX CODE 76...... DEFAULT TAX RATE 76...... REPORT PRINTER TYPE 76...... REPORT PRINTER PORT 76...... HAND CHECKS PRINTER PORT 76...... BATCH CHECKS PRINTER PORT 77...... RECURRING CHECKS PRINTER PORT 77...... AP POSTING - PARTIAL PAYMENT OF PURCHASE ORDERS 77...... AP POSTING - PARTIAL PAYMENT OF PO FREIGHT & ADJUSTMENTS 78...... AUTOMATIC GL POSTING 79...... EDIT CLASS CODE RECORD 79...... ADD NEW CLASS CODE RECORD 80...... FIND CLASS CODE 80...... VISUAL INDEXING 81...... AUTOMATIC DAILY INDEXING 81...... COLOR MONITOR 81...... COLOR INTENSITY 82......MISCELLANEOUS ROUTINES 82...... MISC ROUTINES MENU: 83...... APPEND FROM 85...... BROWSE DATABASES DAYO AP, TJS LAB Orlando, Florida Table of Contents Page Subject ──── ────────────────────────────────────────────────────────── 87...... COPY (.DBF) TO 89...... CREATE DATABASE 91...... DELETE RECORDS 92...... ERASE FILE 92...... EXIT TO DOS 93...... INDEX A DATABASE 94...... LIST FIELDS 97...... MODIFY DATABASE 98...... PACK DATABASE 99...... RECALL RECORDS 99...... RETURN TO MENU 99...... RUN (DOS COMMAND) 100...... SIMPLE EDITOR 101...... SORT DATABASE 102...... TYPE (PRINT) FILE 103...... ZAP DATABASE 105......HELP SCREENS 107...... EXPANDED HELP 107...... USER DEFINED & INPUTTED HELP SCREENS/MESSAGES 108...... VIEW DOCUMENTATION ONSCREEN 109......DATABASE STRUCTURE 120......DATA DICTIONARY 128......DAYO AP MAINTENANCE & QUIRKS 129......TJS 'Computer' LAB DAYO AP, TJS LAB Page: 1 ■ INTRODUCTION DAYO AP is the 'final chapter' in the processing and maintenance of all your Payables. DAYO AP's primary task is to process your purchase orders, however, routines have been provided to handle 'other' expenses. The ability to print payable or miscellaneous checks has been incorporated in DAYO AP. Many reports are included to aid you in your accounting. DAYO AP is by default a multiuser system. Some of the DAYO AP highlights are: Multiuser (ie: Novell) Hand/Manual Checks Batch Checks Recurring Checks Unlimited Bank Accounts Unlimited Check Printing Formats 28+ Reports Print 1099 MISC Forms Purchase Clearing Vendor Maintenance Inventory Maintenance/Adjustments Data Entry Validation Databases are dBase (tm) compatible 19+ Configuration Settings Passwords (with DAYO Passwords) Other DAYO Products: DAYO Inventory Inventory Control, Vendors, Purchasing, Receiving DAYO POS Point of Sales Billing & Invoicing DAYO Quotes Sales Quoting System DAYO Price Books Special pricing for your customers as well as a wide range of product catalogs/reports DAYO AR Accounts Receivable DAYO EOP End of Period Post & Pack, Physical Inventory DAYO BO Back Orders DAYO Smart Reports A variety of reports pertaining to the above modules DAYO Passwords Password protect your DAYO system DAYOX Network/LAN Index Maintenance Utility DAYO AP, TJS LAB Page: 2 ■ COPYRIGHT/LICENSE This manual and software is copyrighted with all rights reserved by TJS LAB. No copying of this manual or software is authorized without the prior written consent of TJS LAB. An exception to this rule is the making of backup copies of registered software disks. No RESALE of any part of the source codes is authorized without the prior written consent of TJS LAB. TJS LAB retains all rights to DAYO AP software, documentation, and source codes. ■ DISCLAIMER No warrant is made that this software will work in all environments, or with all resident programs and hardware configurations. TJS LAB has tested this software in many environments and found it to perform as expected, however, this software is licensed "AS IS". TJS LAB will not be liable for any damage done to your data, hardware, and/or software systems as a result of using DAYO AP. ■ REQUIREMENTS *** IBM or Compatible CPU 640K memory * DOS 3.3 or above Hard Disk ■ SETUP To setup DAYO AP, run the Setup program found on the DAYO Menu and DAYO Update & Conversion diskettes. If this is the Shareware Version, UnZip/UnArc the files into a directory named \DAYOAP. When running DAYO AP for the first time, it will create all the database, index, and configuration files it requires for operation. If you are using other DAYO modules, be sure to enter the location of these databases into the DAYO AP configuration. Type and enter 'DAYOV' at the DOS prompt to run the program. *** Your CONFIG.SYS file must have the buffers set to a minimum of 10, and your files must have a MINIMUM setting of 55! Failure to edit the CONFIG.SYS file is the #1 cause for DAYO installation problems! A CONFIG.SYS file is created if there is a problem detected, in the directory that this DAYO module is being run in. You may copy this file into your root/boot drive. Refer to your DOS manual for more information on the CONFIG.SYS file! DAYO AP, TJS LAB Page: 3 ■ MAIN MENU After a few moments, and possibly a reindex, the main menu will appear (the left side of the screen is the actual main menu): DAYO AP Version 4.00 TJS LAB, Inc. ┌─────[June 1992]────┐ ╓────────────────────╖ │S M T W T F S │ ║ 1 BROWSE ║ ██▄████░ ▄███▄ ██░ ██░ ██████░ ├────────────────────┤ ╟────────────────────╢ ██░ ██░ ██░██░ ██░ ██░ ██░ ██░ │ 1 2 3 4 5 6│ ║ 2 BATCH CHECKS ║ ██░ ██░ ██░██░ ▀████▀ ██░ ██░ │ 7 8 9 10 11 12 13│ ╟────────────────────╢ ██░ ██░ ██▀▀▀██░ ▀██▀ ██░ ██░ │14 15 16 17 18 19 20│ ║ 3 MANUAL CHECKS ║ ██░ ██░ ██░ ██░ ██░ ██░ ██░ │21 22 23 24 25 26 27│ ╟────────────────────╢ █▀█████░ ██░ ██░ ██░ ██████░ │28 29 30 │ ║ 4 POSTING ║ │ │ ╟────────────────────╢ Copyright (c) 1989-1992 └────────────────────┘ ║ 5 REPORTS ║ ╓────────────────────────────────────────────────╖ ╟────────────────────╢ ║ DAYO AP STATISTICS ║ ║ 6 CONFIGURATION ║ ╟────────────────────────────────────────────────╢ ╟────────────────────╢ ║ DATABASE NAME RECORDS SIZE ║ ║ 7 MISC ROUTINES ║ ╟────────────────────────────────────────────────╢ ╟────────────────────╢ ║ POH.DBF PO Headers 37 32K ║ ║ 8 EXIT ║ ║ POD.DBF PO Detail 168 25K ║ ╚════════════════════╝ ║ APH.DBF AP Header 217 126K ║ ██░ ██▄█████ ║ APD.DBF AP Detail 118 17K ║ ████░ ██░ ██░ ║ VENDORS.DBF Vendors 2 3K ║ ██ ██░ ██░ ██░ ║ EXPENSES.DBF Misc Expenses 2 1K ║ ▄██▄▄██▄ ████████ ║ CHECKS.DBF Check Register 211 47K ║ ██ ██░ ██░ ║ DEPOSITS.DBF Deposits 20 3K ║ ██░ ██░ ██░ ╚══════════[ Press Alt F9 To Reindex ]═══════════╝ Browse-Edit-Maintenance Your AP Databases The size and number of records for your some of your key AP databases are displayed in the box on the lower right of the screen. ■ PASSWORD/NAME From the main menu you can enter any of the routines/options, but first you must your name (or password if using DAYO Passwords): ┌────────────────────────────────────────────────────────────────────────────┐ │┌──────────────────────────────────────────────────────────────────────────┐│ ││ Enter Your Name: George Moonilal ││ │└──────────────────────────────────────────────────────────────────────────┘│ └────────────────────────────────────────────────────────────────────────────┘ DAYO AP, TJS LAB Page: 4 ■ BROWSE Use the BROWSE routines to view, edit, and maintenance your AP databases. There are 14 AP databases that this routines supports: AP Header (APH.DBF) Warehouses (WAREHOUS.DBF) AP Detail (APD.DBF) Warehouse Names (WARENAME.DBF) Vendors (VENDORS.DBF) Receivers (REC.DBF) PO Header (POH.DBF) Checking Accounts (ACCOUNTS.DBF) PO Detail (POD.DBF) Checks (CHECKS.DBF) Inventory (INV.DBF) Check Formats (CFORMAT.DBF) Inventory Adjustments (INVADJ.DBF) Deposits (DEPOSITS.DBF) Unlike the BROWSE in the MISC ROUTINES, these BROWSES are more 'controlled'. The BROWSE in the MISC ROUTINES will not open all indexes for a database, whereas the AP BROWSE does, and often opens other related databases. A few options are available while in the BROWSE. You can do a Full Screen Edit, add a blank record, delete a record, and if there are indexes for the selected databases, find a record based on any of the indexes. Remember, there are usually more fields to the 'right' of the screen (Press F1 for HELP - more information). *** Adding a record (Ctrl N) will not, in all cases, update/create a new 'control number' (ie: PO number, Journal Number....). *** Note! Very little data entry validation takes place in a BROWSE, so be careful when making any edits! DAYO AP, TJS LAB Page: 5 ■ BROWSE ACCOUNTS PAYABLE HEADERS The AP Header database (APH.DBF), is the Accounts Payable Ledger! It is from this database that all payable reports (ie: AGEING), derive their data. The posting of inventory/purchase order receipts creates records in this database, but many (sometimes most), of the records/payables/invoices will be created 'manually' (ie: pressing 'Ctrl N'). Unlike the other browse routines in this group, this one does 'validate' data entry. DAYO AP Version 4.0 TJS LAB ╔═══[ APH.DBF ]══════════════════════════════════════════════════════════════╗ ║Journal # Name * Recurring PO Vendor Open PurC║ ║ 85 RON DAVIDSON 500030 RD-100 Yes No ║ ║Date Receiver Check # PO Date Comment ║ ║03/28/90 66440 23443 12/15/89 Hand Credit Check ║ ║ Taxes Adjustment Freight Subtotal Total Amount ║ ║ 0.00 1.00 10.00 200.00 211.00 65.00 ║ ╚══════════════[ Browse the Accounts Payable Header Database ]═══════════════╝ JOURNAL PO VENDOR NAME ─────────────────╥────────╥────────────╥────────────────────────────────────── 77 ║ 500022 ║ HURCLE ║ HURCLE SUPPLIES 78 ║ 500023 ║ BORDEN ║ BORDEN SOFTDRINKS, INC 79 ║ 500024 ║ MAO A ║ MAO BUSINESS FORMS 80 ║ 500025 ║ HARPER BK ║ HARPER BOOKS 81 ║ 500026 ║ JOE MORGAN ║ JOE MORGAN ENTERPRISES 82 ║ 500027 ║ ZZZ ║ ZENTIL Z. ZEBULA PRINTING 83 ║ 500028 ║ ZZZ ║ ZENTIL Z. ZEBULA PRINTING 84 ║ 500029 ║ ZZZ ║ ZENTIL Z. ZEBULA PRINTING 85 ║ 500030 ║ RD ║ RON DAVIDSON 86 ║ 500031 ║ RD ║ RON DAVIDSON 87 ║ 500032 ║ MAO A ║ MAO BUSINESS FORMS Esc (Exit) F1 (Help) F2 (Edit) Ctrl N (Add) Ctrl U (Delete/Recall) Find: F5 (PO) F6 (Name) F7 (Vendor Number) F8 (Journal Number) 53/55 DAYO AP, TJS LAB Page: 6 ■ BROWSE ACCOUNTS PAYABLE HEADERS - FULL SCREEN EDIT ┌────────────────────────────[ FULL SCREEN EDIT ]────────────────────────────┐ │ JOURNAL: 85 SUBTOTAL: 200.00 │ │ PO: 0 TAXES: 0.00 │ │ VENDOR: RD ADJUST: 1.00 │ │ NAME: RON DAVIDSON FREIGHT: 10.00 │ │ ATTN: RON AMOUNT: 65.00 │ │ ADDR1: 9290 LAKELAND AVE PC: F │ │ ADDR2: CHECKNO: 23443 │ │ CITY: LAKELAND PODATE: 12/15/89 │ │ STATE: FL TYPE: AA │ │ ZIP: 39399 │ │ PHONE: (813)-555-2933 │ │ DATE: 03/28/90 │ │ ETA: / / │ │ TERMS: CHECK │ │ SHIPPER: MAIL │ │ BY: TJ │ │ PRINTED: F │ │ COMMENT: Hand Credit Check Or │ │ RECDATE: / / │ │ KEY: 66440 │ │ OPEN: T │ └────────────────────────────────────────────────────────────────────────────┘ Press Esc to Abort, PgUp/PgDn to Save and Exit ■ ADD A NEW AP RECORD/INVOICE ┌──────────────────────[ ADD A NEW AP RECORD/INVOICE ]───────────────────────┐ │ Journal: 0 Vendor: TJ Ship To Name & Address │ │ TOM JOHNSON │ │ PO: 0 Control: │ │ Attn: SDF │ │ Bill To Address: , │ │ asdfasdfasdf Zip: │ │ AS Ship Phone: │ │ DFA , SF ASDF │ │ Phone: ASDFASDFA │ │ Amount: 0.00 Taxes: 0.00 │ │ Subtotal: 0.00 Adjustment: 0.00 │ │ Freight: 0.00 Paid: 0.00 │ │ Shipper: Terms: │ │ Printed: Y │ │ Open: Y │ │ Type: ASF │ │ Class: ASF │ │ Paydate: 04/14/92 │ │ Comment: │ │ Purchase Cleared: Y │ │ Recurring?: N Every X Days: 1 (Okay to Pay) │ └────────────────────────────────────────────────────────────────────────────┘ DAYO AP, TJS LAB Page: 7 ■ BROWSE ACCOUNTS PAYABLE DETAIL The AP Detail records are records of your detail payables, which are usually created from posting your closed Purchase Orders. DAYO AP Version 4.0 TJS LAB ╔═══[ APD.DBF ]══════════════════════════════════════════════════════════════╗ ║Journal # Name PO Vendor Open PurC║ ║ 1077 RON DAVIDSON 1205 RD No Yes ║ ║Date Receiver Check # PO Date Comment ║ ║03/10/90 1245 02/25/90 ║ ║ Taxes Adjustment Freight Subtotal Total Amount ║ ║ 36.36 524.87 524.87 606.00 1692.10 1574.61 ║ ║Item Description VendItem Cost Tax ║ ║RD-34 CAR, 1989 (GENERAL) 34 303.00 Yes ║ ╚══════════════[ Browse the Accounts Payable Detail Database ]═══════════════╝ JOURNAL PO VENDOR ITEM DESC ────────╥────────╥────────────╥──────────────╥─────────────────────────────── 1072 ║ 1200 ║ MAO A ║ ║ * Voided while in Receiving * 1073 ║ 1201 ║ MAO A ║ 1900001 ║ PAPER, 12 BOND, UTILITY 1073 ║ 1201 ║ MAO A ║ ║ * Voided while in Receiving * 1074 ║ 1202 ║ RD ║ RD-3934 ║ 1978 MUSTANG, (NEEDS PAINT) 1074 ║ 1202 ║ RD ║ RD-0303 ║ 1966 CHEVY 1075 ║ 1203 ║ RD ║ RD-10100 ║ 1956 CHEVY, RED (NO MOTOR) 1076 ║ 1204 ║ RD ║ RD-838383 ║ PER HOUR LABOR (MISC) 1076 ║ 1204 ║ RD ║ RD-00001 ║ HAULER, MOBILE, 3 TON 1077 ║ 1205 ║ RD ║ RD-34 ║ CAR, 1989 (GENERAL) Esc (Exit) F1 (Help) F2 (Edit) Ctrl N (Add) Ctrl U (Delete/Recall) Find: F5 (PO) F6 (Item) F7 (Vendor) F8 (VendItem) F9 (Journal) 154/154 ■ BROWSE ACCOUNTS PAYABLE DETAIL - FULL SCREEN EDIT DAYO AP Version 4.0 TJS LAB ┌────────────────────────────[ FULL SCREEN EDIT ]────────────────────────────┐ │ JOURNAL: 1077 │ │ PO: 1205 │ │ VENDOR: RD │ │ ITEM: RD-34 │ │ DESC: CAR, 1989 (GENERAL) │ │ VENDITEM: 34 │ │ QUANTITY: 2 │ │ COST: 303.00 │ │ DATE: 03/10/90 │ │ TYPE: CAR │ │ CLASS: U │ │ OPEN: T │ │ KEY: 1245 │ │ RECDATE: / / │ │ TAXABLE: T │ └────────────────────────────────────────────────────────────────────────────┘ Press Esc to Abort, PgUp/PgDn to Save and Exit DAYO AP, TJS LAB Page: 8 ■ BROWSE VENDORS DATABASE The DAYO Inventory has a better routine for the maintenance of your Vendors, however, at times this Browse may be more convenient... DAYO AP Version 4.0 TJS LAB ╔═══[ \DAYOINV\VENDORS.DBF ]═════════════════════════════════════════════════╗ ║Vendor # Name Phone LastDate Type ║ ║ADDDD ABLE STORES 345-5050 03/06/90 MC ║ ║Terms Shipper ║ ║NET 30 DELIVER NEXT DAY ║ ║TaxRate Open Purc Recv Purc Total Purc Due Paid TotalPaid║ ║ 0.000 17590.23 340.07 23440.60 17161.34 4296.00 27329.25║ ╚══════════════════════[ Browse the Vendors Database ]═══════════════════════╝ VENDOR NAME ADDR1 ────────────╥────────────────────────────────╥─────────────────────────────── AAAAB ║ AL MORGAN ║ 68009 EAST LANCASTER RD AAAAC ║ JON MORGAN, INC ║ RT. 3900 AAAAD ║ SUE MORGAN SUPPLIES ║ 4449 BEARMAN STREET AAAAE ║ MARTIN JONES, INC ║ PO BOX 9090 ADDDD ║ ABLE STORES ║ 30 EAST CORNER, 3 POINTS ADDDE ║ HOT STUFF, BUSINESS FORMS ║ 678 LEE ROAD ADDDEF ║ DOLPHIN PAPER, INC. ║ PIER 9 ADDERT ║ STEVENS PRINTING AND SUPPLIES ║ 5395 BABLEE DRIVE ADDERU ║ STEVENS PRINTING ║ PO BOX 9001 ADDH ║ ARLIE JOHNSON PAINTS ║ 90033 E. TROY ROAD ADDJ200 ║ 2000 IDEAS, INC ║ 200 EAST LANE Esc (Exit) F1 (Help) F2 (Edit) Ctrl N (Add) Ctrl U (Delete/Recall) Find: F5 (Vendor Number) F6 (Vendor Name) 323/43021 DAYO AP, TJS LAB Page: 9 ■ BROWSE VENDORS DATABASE - FULL SCREEN EDIT DAYO AP Version 4.0 TJS LAB ┌────────────────────────────[ FULL SCREEN EDIT ]────────────────────────────┐ │ VENDOR: ADDDD PAID: 4296.50 │ │ NAME: ABLE STORES TOTALPAID: 27329.25 │ │ ADDR1: 30 EAST CORNER, 3 POINTS │ │ ADDR2: │ │ CITY: LONGWOOD │ │ STATE: FL │ │ ZIP: 32749 │ │ PHONE: 831-4040 │ │ ATTN: SUE │ │ TERMS: NET 30 │ │ SHIPPER: DELIVER NEXT DAY │ │ DATE: 11/10/87 │ │ LASTDATE: 03/06/90 │ │ TYPE: MC │ │ CLASS: STO │ │ TAXRATE: 0.000 │ │ FED_ID: 9300-397845 │ │ OPEN_PURC: 17590.23 │ │ RECV_PURC: 340.07 │ │ TOT_PURC: 27329.25 │ │ DUE: 17161.34 │ └────────────────────────────────────────────────────────────────────────────┘ Press Esc to Abort, PgUp/PgDn to Save and Exit DAYO AP, TJS LAB Page: 10 ■ BROWSE PURCHASE ORDER HEADERS Purchase Orders are created with the DAYO Inventory module, and can be maintained with that program or with this DAYO AP Browse of the Purchase Order Header records. DAYO AP Version 4.0 TJS LAB ╔═══[ \DAYOINV\POH.DBF ]═════════════════════════════════════════════════════╗ ║ PO Name Vendor Open Printed BY ║ ║ 39 ACME JAR ACME JAR No Yes TIM ║ ║Terms Shipper DATE ETA ║ ║NET 60 ROADWAY 03/28/90 03/29/90 ║ ║ Taxes Adjustment Freight Subtotal Paid Total Due ║ ║ 0.18 0.00 0.00 6.00 0.00 6.18 ║ ║Comment ║ ║Fill back orders immediately! ║ ╚════════════[ Browse the Purchase Orders (PO) Header Database ]═════════════╝ PO VENDOR NAME ────────────────────╥────────────╥─────────────────────────────────────────── 31 ║ ACE ║ ACE SUPPLIES 32 ║ ACME JAR ║ ACME JAR 33 ║ ACME JAR ║ ACME JAR 34 ║ ACME JAR ║ ACME JAR 35 ║ ACME JAR ║ ACME JAR 36 ║ ACME JAR ║ ACME JAR 37 ║ ACME JAR ║ ACME JAR 38 ║ ACME JAR ║ ACME JAR 39 ║ ACME JAR ║ ACME JAR Esc (Exit) F1 (Help) F2 (Edit) Ctrl N (Add) Ctrl U (Delete/Recall) Find: F5 (PO) F6 (Name) F7 (Vendor Number) 22/22 DAYO AP, TJS LAB Page: 11 ■ BROWSE PURCHASE ORDER HEADERS - FULL SCREEN EDIT DAYO AP Version 4.0 TJS LAB ┌───────────────────────────[ FULL SCREEN EDIT ]─────────────────────────────┐ │ PO: 39 PRINTED: T │ │ VENDOR: ACME JAR COMMENT: Fill back orders immed │ │ NAME: ACME JAR │ │ ATTN: │ │ ADDR1: 400 WEST LAKE ROAD │ │ ADDR2: WAREHOUSE #10 │ │ CITY: WRIGHTSBORO │ │ STATE: GA │ │ ZIP: 23619 │ │ PHONE: (404) 932-1922 │ │ DATE: 03/28/90 │ │ ETA: 03/29/90 │ │ SUBTOTAL: 6.00 │ │ TAXES: 0.18 │ │ ADJUST: 0.00 │ │ FREIGHT: 0.00 │ │ PAID: 0.00 │ │ TERMS: NET 60 │ │ SHIPPER: ROADWAY │ │ BY: TIM │ │ OPEN: F │ └────────────────────────────────────────────────────────────────────────────┘ Press Esc to Abort, PgUp/PgDn to Save and Exit DAYO AP, TJS LAB Page: 12 ■ BROWSE PURCHASE ORDER DETAIL The PO Detail records can be edited using this routine. Keep in mind that any change in the detail record will not update the header record (ie: changing the cost of an item will not adjust the subtotal in the header record). DAYO AP Version 4.0 TJS LAB ╔═══[ \DAYOINV\POD.DBF ]═════════════════════════════════════════════════════╗ ║PO Name Vendor Open Printed BY ║ ║ 39 ACME JAR ACME JAR No Yes TIM ║ ║Terms Shipper DATE ETA ║ ║NET 60 ROADWAY 03/28/90 03/29/90 ║ ║ Taxes Adjustment Freight Subtotal Paid Total Due ║ ║ 0.18 0.00 0.00 6.00 0.00 6.18 ║ ║Comment ║ ║Fill back orders immediately! ║ ║Item Description VendItem Cost Tax ║ ║JAR-1 Jar, Small, Red AJ-123456 1.00 Yes ║ ╚════════════[ Browse the Purchase Orders (PO) Detail Database ]═════════════╝ PO VENDOR ITEM DESC ────────────╥────────────╥──────────────╥──────────────────────────────────── 34 ║ ACME JAR ║ JAR-03 ║ Jar, Wide Mouth 39 ║ ACME JAR ║ JAR-1 ║ Jar, Small, Red 40 ║ ACME JAR ║ JAR-102 ║ Jar, #1 Blue 40 ║ ACME JAR ║ JAR-39 ║ Jar, #1 Red 40 ║ ACME JAR ║ JAR-3902 ║ Jar, Red 41 ║ ACME JAR ║ JAR-3904 ║ Jar, Green 41 ║ ACME JAR ║ JAR-3914 ║ Jar, Lavender, Plastic Esc (Exit) F1 (Help) F2 (Edit) Ctrl N (Add) Ctrl U (Delete/Recall) Find: F5 (PO) F6 (Item) F7 (Vendor Name) F8 (Vendor Number) 37/38 DAYO AP, TJS LAB Page: 13 ■ BROWSE PURCHASE ORDER DETAIL - FULL SCREEN EDIT DAYO AP Version 4.0 TJS LAB ┌───────────────────────────[ FULL SCREEN EDIT ]─────────────────────────────┐ │ PO: 39 │ │ VENDOR: ACME JAR │ │ ITEM: JAR-1 │ │ DESC: Jar, Small, Red │ │ VENDITEM: AJ-123456 │ │ ORDERED: 2 │ │ RECEIVED: 0 │ │ COST: 1.00 │ │ DATE: 03/28/90 │ │ ETA: 03/29/90 │ │ LASTRECV: / / │ │ TYPE: XXX │ │ CLASS: JAR │ │ OPEN: T │ │ TAXABLE: T │ │ │ │ │ └────────────────────────────────────────────────────────────────────────────┘ Press Esc to Abort, PgUp/PgDn to Save and Exit DAYO AP, TJS LAB Page: 14 ■ BROWSE MAIN INVENTORY DATABASE This BROWSE is the same as the routine found in the DAYO Inventory module. Unlike other routines in AP BROWSE, this Inventory BROWSE also adds 2 more options; to 'move/transfer' quantity between warehouses; and to make inventory adjustments. Note, only the first 3 warehouse fields (LOC1, LOC2, LOC3), are displayed onto the top of the screen. You can see, but not edit, the rest by moving the cursor to the rightmost fields (Press F1 for Help/more information). DAYO AP Version 4.0 TJS LAB BROWSE ┌───[February 1992]──┐ ┌────[ \DAYOINV\INV.DBF ]──────────────────────────────┐│S M T W T F S │ │Item: JAR-1 Desc: Jar, #1 │├────────────────────┤ │Vendor Item: AJ-123456 Vendor: RD ││ 1 2 3 4 5 6 7│ │Onhand: 3 On Order: 302 ││ 8 9 10 11 12 13 14│ │PTD Sold: 2 YTD Sold: 340 ││15 16 17 18 19 20 21│ │Cost: 1.00 Price: 2.00 Retail: 3.00││22 23 24 25 26 27 28│ │Type: XXX Class: JAR Taxable: Y Serial No: N ││29 30 │ │Warehouses Loc1: 0 Loc2: 0 Loc3: 0 ││ │ └────────────────────────[ Inventory Database Browse ]─┘└────────────────────┘ ITEM DESC ONHAND ONORDER BO ───────────────╥────────────────────────────────╥─────────╥─────────╥───────── JAR-1 ║ Jar, #1 ║ 3 ║ 302 ║ 100 JAR-2 ║ Jar, #2 ║ 1 ║ 606 ║ 20 JAR-3 ║ Jar, #2 ║ 1 ║ 901 ║ 430 ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ Esc (Exit) F1 (Help) F2 (Edit) F4 (Warehouses) Shift F1 (Adjustment) Ctrl N (Add) Ctrl U (Delete) Find F5 (Item) F6 (Desc) F7 (Vendor) F8 (VendItem) F9 (Type) 1/3 DAYO AP, TJS LAB Page: 15 ■ BROWSE MAIN INVENTORY DATABASE - FULL SCREEN EDIT Press F2 to bring up a Full Screen data entry screen: DAYO AP Version 4.0 TJS LAB BROWSE ┌───[February 1992]──┐ ┌───────────────────────────[ FULL SCREEN EDIT ]─────────────────────────────┐ │ ITEM: JAR-1 LOCATION: STO │ │ DESC: Jar, #1 │ │ ONHAND: 3 │ │ ONORDER: 302 │ │ BO: 100 │ │ SOLDPTD: 2 │ │ SOLDYTD: 0 │ │ VENDITEM: AJ-123456 │ │ VENDOR: SDF │ │ DATE: / / │ │ LASTDATE: / / │ │ COST: 1.00 │ │ RETAIL: 3.00 │ │ PRICE: 2.00 │ │ STOCKLEVEL: 66 │ │ TYPE: XXX │ │ CLASS: JAR │ │ TAXABLE: T │ │ SERIALNO: F │ │ WEIGHT: 4.25 │ │ UNIT: EA │ └────────────────────────────────────────────────────────────────────────────┘ Press Esc to Abort, PgUp/PgDn to Save and Exit DAYO AP, TJS LAB Page: 16 ■ BROWSE MAIN INVENTORY DATABASE - WAREHOUSE TRANSFER Press F4 to 'move'/transfer item quantities from one warehouse into another. Valid warehouses include the Onhand field (for the main inventory - INV.DBF), and all fields that start with 'LOC' (ie: LOC1, LOC2 ...), that are located in the database WAREHOUS.DBF. To move quantity, select a warehouse that has a quantity greater than zero, and press enter/return. DAYO AP Version 4.0 TJS LAB BROWSE ┌───[February 1992]──┐ ┌────[ \DAYOINV\INV.DBF ]───────────────────┌─────────────────────┐ T F S │ │Item: JAR-1 Desc: Jar, #1 │ WAREHOUSE TRANSFERS │──────────┤ │Vendor Item: AJ-123456 Vendor: RD ╞═════════════════════╡4 5 6 7│ │Onhand: 3 On Order: 302 │ Warehouse Qty │1 12 13 14│ │PTD Sold: 2 YTD Sold: 340 │ Onhand 400 │8 19 20 21│ │Cost: 1.00 Price: 2.00 Retail:│ LOC1 0 │5 26 27 28│ │Type: XXX Class: JAR Taxable: Y Serial No:│ SLLOC1 1 │ │ │Warehouses Loc1: 0 Loc2: 0 Loc3: │ LOC2 0 │ │ └──────────────────────[ Inventory Database │ SLLOC2 0 │──────────┘ │ LOC3 0 │ ITEM DESC │ SLLOC3 0 │ BO ─────────────╥────────────────────────────│ LOC4 0 │─────────── JAR-1 ║ Jar, #1 │ SLLOC4 0 │ 101 JAR-2 ║ Jar, #2 │ LOC5 0 │ 43 JAR-3 ║ Jar, #3 │ SLLOC5 0 │ 23 ║ │ LOC6 0 │ ║ ╞═════════════════════╡ ║ │ Select a Warehouse │ ║ │ with a quantity > 0 │ ║ │ to transfer quantity│ Esc (Exit) F1 (Help) F2 (Edit) F4 (W│ FROM... │justment) Ctrl N (Add) Ctrl U (Delete) └─────────────────────┘ Find F5 (Item) F6 (Desc) F7 (Vendor) F8 (VendItem) F9 (Type) 1/3 A prompt will appear onto the screen requesting you to enter the quantity that you wish to transfer. The default is the total quantity from the warehouse that is losing the quantity. After making your edit, press enter/return to log/post the change. ┌────────────────────────────────────────────────┐ │ Enter Quantity to be Transferred: 400 │ └────────────────────────────────────────────────┘ DAYO AP, TJS LAB Page: 17 ■ BROWSE MAIN INVENTORY DATABASE - INVENTORY ADJUSTMENT Press Shift F1 to make an Inventory Adjustment. Inventory Adjustments should only be made to make a correction to the normal, computer maintained process of adjusting the inventory via the DAYO POS, Receiving, and AP modules/programs. To make an Inventory Adjustment permanent (post), you must enter a reason for the edit/adjustment (anything, except spaces, is acceptable). DAYO AP Version 4.0 TJS LAB BROWSE ┌───[February 1992]──┐ ┌──────────────────────────────────────────────────────┐│S M T W T F S │ │Item: JAR-1 Desc: Jar, #1 │├────────────────────┤ │Vendor Item: AJ-123456 Vendor: SDF ││ 1 2 3 4 5 6 7│ │Onhand: 210 On Order: 302 ││ 8 9 10 11 12 13 14│ │PTD Sold: 2 YTD Sold: 0 ││15 16 17 18 19 20 21│ │Cost: 1.00 Price: 2.00 Retail: 3.00 ││22 23 24 25 26 27 28│ │Type: XXX Class: JAR Taxable: Y Serial No: N ││29 30 │ │Warehouses Loc1: 3 Loc2: 10 Loc3: 0 ││ │ │ INVENTORY ADJUSTMENT │└────────────────────┘ │ Cost: 1.00│ A positive Qty adds to the │ │ Price: 2.00│ inventory. │ ONORDER BO │ Retail: 3.00│ A negative Qty removes from │╥─────────╥─────────── │ Qty: 1│ the inventory. │║ 302 ║ 100 │ Reason: Internal Use │║ 606 ║ 200 └──────────────────────────────────────────────────────┘║ 901 ║ 300 ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ Esc (Abort) You must Enter a REASON to complete the Adjustment! DAYO AP, TJS LAB Page: 18 ■ BROWSE INVENTORY ADJUSTMENTS DATABASE All 'manual' Inventory Adjustments are found in the database INVADJ.DBF. You can view and/or edit adjustments, however editing adjustments is not recommended. Note, the operator name that made the adjustment is included on the record. The VARIANCE field is computed as follows: VARIANCE = ( INVENTORY COST - ADJUSTED COST ) * ( NEW ONHAND TOTAL ) Note, the VARIANCE equals zero if the COST remains the same... DAYO AP Version 4.0 TJS LAB ╔═══[ \DAYOINV\INVADJ.DBF ]══════════════════════════════════════════════════╗ ║Item VendItem Description Date ║ ║JAR-1 AJ-123456 Jar, #1 02/18/90 ║ ║ Qty Cost Price Retail Variance ║ ║ 30 99.50 147.00 199.99 0.00 ║ ║Reason By/Operator ║ ║FOUND IN THE STORE ROOM Tim Johnson ║ ╚═══════════════[ Browse the Inventory Adjustments Database ]════════════════╝ ITEM VENDITEM QTY COST PRICE RETAIL ──────────────╥──────────────╥─────────╥────────────╥────────────╥─────────── JAR-1 ║ AJ-123456 ║ 30 ║ 99.50 ║ 147.00 ║ 199.99 JAR-2 ║ AJ-123457 ║ 430 ║ 35.43 ║ 98.99 ║ 121.99 JAR-3 ║ AJ-123458 ║ 32 ║ 94.50 ║ 139.49 ║ 299.49 JAR-4 ║ AJ-123459 ║ 789 ║ 345.50 ║ 549.99 ║ 899.99 JAR-5 ║ AJ-223460 ║ 150 ║ 95.50 ║ 149.99 ║ 299.99 JAR-6 ║ AJ-223461 ║ 330 ║ 19.50 ║ 89.99 ║ 119.99 JAR-7 ║ AJ-223462 ║ 156 ║ 29.50 ║ 99.99 ║ 129.99 JAR-8 ║ AJ-223463 ║ 164 ║ 39.50 ║ 109.99 ║ 139.99 JAR-12 ║ AJ-223464 ║ 34 ║ 49.50 ║ 119.99 ║ 149.99 JAR-13 ║ AJ-223466 ║ 3 ║ 59.50 ║ 129.99 ║ 159.99 JAR-13A ║ AJ-323467 ║ 0 ║ 69.50 ║ 139.99 ║ 169.99 JAR-14 ║ AJ-453488 ║ 345 ║ 79.50 ║ 149.99 ║ 179.99 ║ ║ ║ ║ ║ Esc (Exit) F1 (Help) F2 (Edit) Ctrl N (Add) Ctrl U (Delete/Recall) 10/11 DAYO AP, TJS LAB Page: 19 ■ BROWSE INVENTORY ADJUSTMENTS DATABASE - FULL SCREEN EDIT Press F2 to bring up a Full Screen data entry screen: DAYO AP Version 4.0 TJS LAB ┌─────────────────────────────[ FULL SCREEN EDIT ]───────────────────────────┐ │ ITEM: JAR-1 │ │ VENDITEM: AJ-123456 │ │ QTY: 30 │ │ COST: 99.50 │ │ PRICE: 147.00 │ │ RETAIL: 199.99 │ │ DOLLARS: 0.00 │ │ REASON: FOUND IN THE STORE │ │ BY: Tim Johnson │ │ DATE: 02/18/90 │ │ │ │ │ │ │ └────────────────────────────────────────────────────────────────────────────┘ Press Esc to Abort, PgUp/PgDn to Save and Exit DAYO AP, TJS LAB Page: 20 ■ BROWSE WAREHOUSE INVENTORY DATABASE DAYO currently supports multiple warehouses to the extent that it provides the mechanism to 'move'/transfer quantities into the database WAREHOUS.DBF. DAYO does not have any computerized routine that will automatically adjust the inventory (ie: DAYO POS, Receiving...). DAYO AP Version 4.0 TJS LAB ┌────[ \DAYOINV\WAREHOUS.DBF ]───────────────────────────────────────────────┐ │ Item VendItem Description │ │ JAR-1 AJ-123456 Jar, #1 │ │ Cost Price Retail Onhand Main Warehouse │ │ 1.00 2.00 3.00 210 │ └───────────────────[ Inventory Warehouse Database Browse ]──────────────────┘ ITEM LOC1 SLLOC1 LOC2 SLLOC2 LOC3 SLLOC3 ────────────────╥─────────╥─────────╥─────────╥─────────╥─────────╥────────── JAR-1 ║ 0 ║ 1 ║ 0 ║ 10 ║ 0 ║ 0 JAR-2 ║ 3 ║ 3 ║ 0 ║ 10 ║ 3 ║ 0 JAR-4 ║ 30 ║ 2 ║ 0 ║ 10 ║ 0 ║ 0 ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ Esc (Exit) F1 (Help) F2 (Edit) Ctrl N (Add) Ctrl U (Delete) Find F5 (Item) DAYO AP, TJS LAB Page: 21 ■ BROWSE WAREHOUSE INVENTORY DATABASE - FULL SCREEN EDIT Press F2 to bring up a Full Screen data entry screen: DAYO AP Version 4.0 TJS LAB ┌─────────────────────────────[ FULL SCREEN EDIT ]───────────────────────────┐ │ ITEM: JAR-1 │ │ LOC1: 0 │ │ SLLOC1: 1 │ │ LOC2: 0 │ │ SLLOC2: 0 │ │ LOC3: 0 │ │ SLLOC3: 0 │ │ LOC4: 0 │ │ SLLOC4: 0 │ │ LOC5: 0 │ │ SLLOC5: 0 │ │ LOC6: 0 │ │ SLLOC6: 0 │ │ LOC7: 0 │ │ SLLOC7: 0 │ │ LOC8: 0 │ │ SLLOC8: 0 │ │ LOC9: 0 │ │ SLLOC9: 0 │ │ LOC10: 390 │ │ SLLOC10: 3 │ └────────────────────────────────────────────────────────────────────────────┘ Press Esc to Abort, PgUp/PgDn to Save and Exit DAYO AP, TJS LAB Page: 22 ■ BROWSE WAREHOUSE NAMES DATABASE The names of your warehouses are found in the database WARENAME.DBF. For each 'LOC' field in the database WAREHOUS.DBF, add a corresponding/related record to this database. The names of the warehouses are used on some of the DAYO Inventory reports. DAYO AP Version 4.0 TJS LAB ┌────[ \DAYOINV\WARENAME.DBF ]───────────────────────────────────────────────┐ │ Warehouse Name │ │ LOC1 RETURN TO VENDOR FOR REPAIR │ │ Comments │ │ │ └─────────────────[ Inventory Warehouse Name Database Browse ]───────────────┘ LOC NAME ───────────────────────────╥──────────────────────────────────────────────── LOC1 ║ RETURN TO VENDOR FOR REPAIR LOC2 ║ INTERNAL/OFFICE USE LOC3 ║ DISCONTINUED LOC4 ║ DAMAGED LOC5 ║ BUILDING # 1001 LOC6 ║ IN USE, SHOP FLOOR LOC7 ║ OUT ON LOAN ║ ║ ║ Find F5 (Name) 1/7 ■ BROWSE WAREHOUSE NAMES DATABASE - FULL SCREEN EDIT Press F2 to bring up a Full Screen data entry screen: DAYO AP Version 4.0 TJS LAB ┌─────────────────────────────[ FULL SCREEN EDIT ]───────────────────────────┐ │ LOC: LOC1 │ │ NAME: RETURN TO VENDOR FOR │ │ COMMENTS: │ │ │ │ │ │ │ │ │ └────────────────────────────────────────────────────────────────────────────┘ Press Esc to Abort, PgUp/PgDn to Save and Exit DAYO AP, TJS LAB Page: 23 ■ BROWSE RECEIVING DATABASE Each time items are received into your inventory from Vendors, a record is created in the REC.DBF. This record is created by the RECEIVING routine in the DAYO Inventory module. This record is often called a Receiver or KeyRec. These records should be maintain by the computer, and only used to view the data, but you can edit the records. DAYO AP Version 4.0 TJS LAB ┌───[ \DAYOINV\REC.DBF ]─────────────────────────────────────────────────────┐ │ PO Vendor Name Date ETA Open│ │ 30 ACME JAR 11/12/89 02/28/90 No │ │Terms Shipper Receiver Date Purc Cleared │ │NET 60 UPS 03/28/90 Yes │ │Receiver Item VendItem Description │ │ 38 JAR-1 RD1200 Jar, #1 │ │Received Cost Each Extended Cost By │ │ 10.00 4.54 45.40 TOM JOHNSON │ └──────────────[ Inventory Receipts/Receivers Database Browse ]──────────────┘ KEY PO VENDOR ITEM DESC ─────────╥────────╥────────────╥──────────────╥─────────────────────────────── 38 ║ 30 ║ ACME JAR ║ JAR-1 ║ Jar, #1 38 ║ 30 ║ ACME JAR ║ JAR-4 ║ Jar, #4 38 ║ 30 ║ ACME JAR ║ JAR-5 ║ Jar, #5 39 ║ 33 ║ RD ║ LID, #04 ║ LID, # 39 ║ 33 ║ RD ║ LID, #09A ║ LID, # 39 ║ 33 ║ RD ║ LID, #72 ║ LID, # 39 ║ 33 ║ RD ║ LID, #758 ║ LID, # 39 ║ 33 ║ RD ║ LID, #84 ║ LID, # 40 ║ -999 ║ ║ ║ * Voided while in Receiving * 41 ║ 56 ║ AC MAURO ║ AC M123 ║ Jar, #1 Find F5 (Receiver/Key) F6 (PO) F7 (Item) F8 (VendItem) 95/106 DAYO AP, TJS LAB Page: 24 ■ BROWSE RECEIVING DATABASE - FULL SCREEN EDIT Press F2 to bring up a Full Screen data entry screen: DAYO AP Version 4.0 TJS LAB ┌─────────────────────────────[ FULL SCREEN EDIT ]───────────────────────────┐ │ KEY: 38 │ │ PO: 30 │ │ VENDOR: ACME JAR │ │ ITEM: JAR-1 │ │ DESC: Jar, #1 │ │ VENDITEM: RD1200 │ │ RECEIVED: 10 │ │ COST: 4.54 │ │ DATE: 03/28/90 │ │ BY: CURTIS JOHNSON │ │ PC: T │ │ │ │ │ │ │ │ │ └────────────────────────────────────────────────────────────────────────────┘ Press Esc to Abort, PgUp/PgDn to Save and Exit DAYO AP, TJS LAB Page: 25 ■ BROWSE CHECKING ACCOUNTS DATABASE For each Checking Account you should create a record in the database ACCOUNTS.DBF. The presence of a unique account in this database is required before any checks, or AP posting can be accomplished for that account. This routine allows you to add/maintenance your Checking Accounts. If you have only one Checking Account, you can overwrite the default one as listed below: Note, the current BALANCE for each account is computer maintained. DAYO AP Version 4.0 TJS LAB ╔════[ ACCOUNTS.DBF ]════════════════════════════════════════════════════════╗ ║ Number Account # Bank/Account Name Balance║ ║ 1 Checking Account # Your Banks Name ║ ║ Phone Type Date Last Date Last Deposit ║ ║ / / / / ║ ╚══════════════════[ Browse the Checking Accounts Database ]═════════════════╝ NUMBER NAME ACCTNUM BALANCE ─────────╥────────────────────────────────╥──────────────────────╥──────────── 1 ║ Your Banks Name ║ Checking Account # ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ Find F5 (Journal #) F6 (Check #) F7 (Account #) F8 (Name) F9 (For) 1/2 DAYO AP, TJS LAB Page: 26 ■ BROWSE CHECKING ACCOUNTS DATABASE - FULL SCREEN EDIT Press F2 to bring up a Full Screen data entry screen: DAYO AP Version 4.0 TJS LAB ┌─────────────────────────────[ FULL SCREEN EDIT ]───────────────────────────┐ │ NUMBER: 1 │ │ NAME: Your Banks Name │ │ ACCTNUM: Checking Account # │ │ BALANCE: │ │ ADDR1: │ │ ADDR2: │ │ CITY: │ │ STATE: │ │ ZIP: │ │ PHONE: │ │ TYPE: │ │ DATE: / / │ │ LASTDATE: / / │ │ LDEPOSIT: 0.00 │ │ │ │ │ │ │ └────────────────────────────────────────────────────────────────────────────┘ Press Esc to Abort, PgUp/PgDn to Save and Exit DAYO AP, TJS LAB Page: 27 ■ BROWSE CHECKS DATABASE Each time a check is created, the record of it is recorded in the database CHECKS.DBF. DAYO AP Version 4.0 TJS LAB ╔════[ CHECKS.DBF ]══════════════════════════════════════════════════════════╗ ║ Number Account # Bank/Account Name Balance ║ ║ 1 12345-090909 Orlando National Bank 71061.87 ║ ║ Journal Reason/For Type Amount ║ ║ 87 Pay off Company Yacht XXX 1102000.10 ║ ║ Date By/Operator Acct Type # ║ ║ 03/28/90 JOHN SMITH AP - Vendor/Misc RD ║ ╚══════════════[ Browse the (Posted & Printed) Checks Database ]═════════════╝ CHECKNO ACCTNUM NUMBER AMOUNT ───────────────────────╥──────────────────────╥────────╥────────────────────── 100017 ║ 12345-090909 ║ 1 ║ 1102000.10 100018 ║ 12345-090909 ║ 1 ║ 23440.60 100019 ║ 12345-090909 ║ 1 ║ 2000.00 100020 ║ 12345-090909 ║ 1 ║ 37.00 100021 ║ 12345-090909 ║ 1 ║ 57.00 100022 ║ 12345-090909 ║ 1 ║ 49.52 100023 ║ 12345-090909 ║ 1 ║ 80.22 100024 ║ 12345-090909 ║ 1 ║ 345.01 100025 ║ 12345-090909 ║ 1 ║ 7.16 100026 ║ 12345-090909 ║ 1 ║ 453.99 100027 ║ 12345-090909 ║ 1 ║ 23457.49 Find F5 (Journal #) F6 (Check #) F7 (Account #) F8 (Name) F9 (For) 35/35 ■ BROWSE CHECKS DATABASE - FULL SCREEN EDIT Press F2 to bring up a Full Screen data entry screen: DAYO AP Version 4.0 TJS LAB ┌─────────────────────────────[ FULL SCREEN EDIT ]───────────────────────────┐ │ CHECKNO: 100017 │ │ ACCTNUM: Orlando National Bank │ │ NUMBER: 1 │ │ AMOUNT: 1102000.10 │ │ NAME: John Lawn │ │ WHATFOR: Confiscated Yacht (Drugs) │ │ DATE: 03/28/90 │ │ JOURNAL: 87 │ │ ACCOUNT: RD │ │ CV: F │ │ TYPE: 3 │ │ CFORMAT: 1 │ │ BY: tj │ └────────────────────────────────────────────────────────────────────────────┘ Press Esc to Abort, PgUp/PgDn to Save and Exit DAYO AP, TJS LAB Page: 28 ■ BROWSE CHECK PRINTING FORMATS DATABASE For each check form you print (no limit), you must enter the printer settings (ie: length, width, row/column of each printed field). DAYO AP creates a record for one check format sold by NEBS, Computer Forms Division, 500 Main Street, Groton, MA 01471 (800) 225-9550. Their product number for the check that conforms to the Default settings is Q9037. Note, this one was picked because it is a multipurpose check, and TJS LAB staff liked its looks! DAYO AP Version 4.0 TJS LAB ╔════[ CHECK PRINTING FORMATS ]══════════════════════════════════════════════╗ ║ Format Name Check Length Width Voucher Start End║ ║ 1 NEBBS RADIO SHACK CHECK 41 80 4 20 ║ ║ Coordinate Row Column ║ ║Amount (in Words): 29 6 █████░ ║ ║ Amount (numeric): 34 64 █░ ║ ║Payable To (Name): 34 6 █░ ║ ║Payable To Address: 35 6 ████░ █░ ║ ║Customer/Vendor #: 34 40 █░ ▄███▄ █▄██░ █▄█▄█░ ▀▀█▄ ▄███▄ ║ ║ Date of Check: 34 52 █░ █░ █░ █▀ █▀█▀█░ █░ █░ ║ ║ Reason for Check: 39 6 █░ █░ █░ █░ █░█ █░ █▀▀█░ █░ ║ ║ Voucher Column Left: 0 █░ ▀███▀ █░ █░ █░ █▄▄█▄ █▄█░ ║ ║ Voucher Column Right: 80 ──────────────────────────────────────── ║ ║ Printer Setup String [ Use 'esc' in lieu of the escape code -> chr(27) ] ║ ║ ║ ╚════════════════[ Browse the Checking Account Print Formats ]═══════════════╝ CFORMAT NAME ───────────────────────────╥───────────────────────────────────────────────── 1 ║ NEBBS RADIO SHACK CHECK ║ ║ ║ Esc (Exit) F1 (Help) F2 (Edit) Ctrl N (Add) Ctrl U (Delete/Recall) 1/4 The Full Screen Edit functions differently from the other AP BROWSE screens. The data entry prompts replace the displayed values atop the screen. DAYO AP, TJS LAB Page: 29 ■ BROWSE CHECKING ACCOUNT DEPOSITS For each deposit made to any of your checking accounts, you need to add and maintain a record of it in this database (DEPOSITS.DBF). Note, data entry does update the current balance in the ACCOUNTS.DBF. DAYO AP Version 4.0 TJS LAB ╔════[ DEPOSITS.DBF ]════════════════════════════════════════════════════════╗ ║ Number Account # Bank/Account Name Balance║ ║ 1 12345-090909 Orlando National Bank 76061.87║ ║ Deposit Reason/For Type Amount ║ ║ 10223 Operations Fees From KGB KGB 5000.00 ║ ║ Date By/Operator ║ ║ 03/10/90 JOHN SMITH ║ ╚══════════════[ Browse the Checking Account Deposits Database ]═════════════╝ DEPOSIT ACCTNUM NUMBER ────────────────────────────╥──────────────────────╥────────────────────────── 10223 ║ 12345-090909 ║ 1 10224 ║ 12345-090909 ║ 1 10225 ║ 12345-090909 ║ 1 10226 ║ 12345-090909 ║ 1 10227 ║ 12345-090909 ║ 1 10228 ║ 12345-090909 ║ 1 10229 ║ 12345-090909 ║ 1 10230 ║ 12345-090909 ║ 1 10231 ║ 12345-090909 ║ 1 10232 ║ 12345-090909 ║ 1 Find F5 (Deposit) F6 (Account Number) F7 (Number) F8 (Reason/For) 21/22 ■ BROWSE DEPOSITS DATABASE - FULL SCREEN EDIT Press F2 to bring up a Full Screen data entry screen: DAYO AP Version 4.0 TJS LAB ┌─────────────────────────────[ FULL SCREEN EDIT ]───────────────────────────┐ │ DEPOSIT: 10223 │ │ ACCTNUM: 12345-090909 │ │ NUMBER: 1 │ │ WHATFOR: Operations Fees From KGB │ │ TYPE: KGB │ │ AMOUNT: 5000.00 │ │ DATE: 03/10/90 │ │ BY: JOHN SMITH │ │ │ │ │ │ │ └────────────────────────────────────────────────────────────────────────────┘ Press Esc to Abort, PgUp/PgDn to Save and Exit DAYO AP, TJS LAB Page: 30 ■ BATCH CHECKS Check writing in batch mode is accomplished with this option. You can batch print all your 'open' Accounts Payable records, and/or batch print your Recurring Checks. ╔══════════════════════════╗ ║ BATCH CHECKS ║ ╟──────────────────────────╢ ║ Prepare Batch Checks ║ ║ Browse Batch Checks ║ ║ Print Batch Checks Draft ║ ║ Print & Post Batch Check ║ ║ Browse Recurring Checks ║ ║ Print Recurring Draft ║ ║ Print & Post Recurring ║ ║ Exit ║ ╟──────────────────────────╢ ║ Select Option ║ ╚══════════════════════════╝ ■ PREPARE BATCH CHECKS Before running the AP Batch Checks, you must post closed Purchase Order data with the POSTING routine (from the main menu). The next step is to run the 'Prepare Batch Checks' option. This option creates temporary check records in the file TCHECKS.DBF for each Vendor. The amount of check is the sum of that Vendors open payables. After selecting the 'Prepare Batch Checks' option, you will be presented with 3 prompts to enter your Checking Account Number, Check Printing Format, and the starting Check Number. DAYO AP, TJS LAB Page: 31 ■ SELECT CHECKING ACCOUNT NUMBER Only a valid Checking Account Number is accepted at the following prompt. You can, however, enter nothing (spaces), or a wrong Checking Account Number to bring up a browse screen of all the valid Checking Accounts to select from: DAYO AP Version 4.0 TJS LAB CHECKS ┌───[February 1992]──┐ ╔══════════════════════════╗ │S M T W T F S │ ╔═════════════════════════════════════════════════╗▄ ├────────────────────┤ ║ PREPARE BATCH CHECKS ║█░ │ 1 2 3 4 5 6 7│ ║ This routine will sum all the unpaid AP Header ║█░ │ 8 9 10 11 12 13 14│ ║ records for each Vendor, and create a temporary ║█░ │15 16 17 18 19 20 21│ ║ Check Record for it (that you can later edit). ║█░ │22 23 24 25 26 27 28│ ║ ║▀ │29 30 │ ║ Enter Checking Account Number: ║ │ │ ║┌────────────────────────[ Select Checking Account ]───────────────────────┐┘ ║│NUMBER NAME ACCTNUM BALANCE │ ║│───────╥───────────────────────────────╥─────────────────────╥────────────│ ║│1 ║ Your Banks Name ║ Checking Account # ║ 71061.87 │ ║│ ║ ║ ║ │ ║│ ║ ║ ║ │ ║│ ║ ║ ║ │ ║│ ║ ║ ║ │ ║│ ║ ║ ║ │ ║│ ║ ║ ║ │ ║│ ║ ║ ║ │ ╚└──────────────────────────────────────────────────────────────────────────┘ DAYO AP, TJS LAB Page: 32 ■ SELECT CHECK PRINTING FORMAT Like the Checking Account Number prompt, the Check Printing Prompt must be a valid one. Enter nothing, or a wrong Check Printing Format code to bring up a browse screen of all the valid Check Printing Formats to select from: DAYO AP Version 4.0 TJS LAB CHECKS ┌───[February 1992]──┐ ╔══════════════════════════╗ │S M T W T F S │ ╔═════════════════════════════════════════════════╗▄ ├────────────────────┤ ║ PREPARE BATCH CHECKS ║█░ │ 1 2 3 4 5 6 7│ ║ This routine will sum all the unpaid AP Header ║█░ │ 8 9 10 11 12 13 14│ ║ records for each Vendor, and create a temporary ║█░ │15 16 17 18 19 20 21│ ║ Check Record for it (that you can later edit). ║█░ │22 23 24 25 26 27 28│ ║ ║▀ │29 30 │ ║ Enter Checking Account Number: 1 ║ │ │ ║ ║ └────────────────────┘ ║┌──────────────────────[ Select Check Printing Format ]────────────────────┐ ║│ CFORMAT NAME │ ║│──────────────────────────╥───────────────────────────────────────────────│ ║│ 1 ║ NEBBS RADIO SHACK CHECK │ ║│ ║ │ ║│ ║ │ ║│ ║ │ ║│ ║ │ ║│ ║ │ ║│ ║ │ ╚└──────────────────────────────────────────────────────────────────────────┘ DAYO AP, TJS LAB Page: 33 ■ SELECT STARTING CHECK NUMBER A starting check number is required so that all checks can be automatically numbered sequentially. Be very sure to select the right starting number! A progress graph will be displayed during the operation... DAYO AP Version 4.0 TJS LAB CHECKS ┌───[February 1992]──┐ ╔══════════════════════════╗ │S M T W T F S │ ╔═════════════════════════════════════════════════╗▄ ├────────────────────┤ ║ PREPARE BATCH CHECKS ║█░ │ 1 2 3 4 5 6 7│ ║ This routine will sum all the unpaid AP Header ║█░ │ 8 9 10 11 12 13 14│ ║ records for each Vendor, and create a temporary ║█░ │15 16 17 18 19 20 21│ ║ Check Record for it (that you can later edit). ║█░ │22 23 24 25 26 27 28│ ║ ║▀ │29 30 │ ║ Enter Checking Account Number: 1 ║ │ │ ║ ║ └────────────────────┘ ║ Enter Check Format Number: NEBBS RADIO SHACK ║─────────────────────────╖ ║ ║ ║ ║ Enter Beginning Check Number: 32 ║─────────────────────────╢ ║ Vendor Name Amount ║ RECORDS SIZE ║ ║ ACME JAR JOHN SMITH 102.00 ║─────────────────────────╢ ║ ║rs 22 9K ║ ║ ║l 38 5K ║ ║ ║r 55 24K ║ ║ ║l 154 20K ║ ║ ║ 14 5K ║ ║ ║enses 7 1K ║ ╟────────────────┬────────────────┬───────────────╢gister 35 7K ║ ╟█████████████████████████████████████────────────╢ 22 3K ║ ╚════════════════╧════════════════╧═══════════════╝═════════════════════════╝ Standby While I Prepare the Batch Checks! Checks Total: 102.00 DAYO AP, TJS LAB Page: 34 ■ BROWSE BATCH CHECKS You can browse the temporary batch checks until you 'Print & Post Batch Checks' (the 4th option...). DAYO AP Version 4.0 TJS LAB CHECKS ┌───[February 1992]──┐ ╔══════════════════════════╗ │S M T W T F S │ ╔════════════════════════════════════════════════════════════════════════════╗ ║ BROWSE BATCH CHECKS ║ ╟────────────────────────────────────────────────────────────────────────────╢ ║ CHECKNO ACCTNUM NUMBER AMOUNT ║ ║──────────────────────╥──────────────────────╥────────╥─────────────────────║ ║ 10000 ║ 12345-909090 ║ 1 ║ 154.69 ║ ║ 10001 ║ 12345-909090 ║ 1 ║ 134.99 ║ ║ 10002 ║ 12345-909090 ║ 1 ║ 100.57 ║ ║ 10003 ║ 12345-909090 ║ 1 ║ 39.59 ║ ║ 10004 ║ 12345-909090 ║ 1 ║ 39.50 ║ ║ 10005 ║ 12345-909090 ║ 1 ║ 397.75 ║ ║ 10006 ║ 12345-909090 ║ 1 ║ 93.00 ║ ║ 10007 ║ 12345-909090 ║ 1 ║ 193.47 ║ ║ 10008 ║ 12345-909090 ║ 1 ║ 184.43 ║ ║ 10009 ║ 12345-909090 ║ 1 ║ 235.74 ║ ║ 10010 ║ 12345-909090 ║ 1 ║ 100.43 ║ ║ ║ ║ ║ ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit) F1 (Help) F2 (Edit) Ctrl U (Delete) Ctrl N (Add) <NONE> ■ BROWSE BATCH CHECKS - FULL SCREEN EDIT Press F2 for a Full Screen Edit: DAYO AP Version 4.0 TJS LAB CHECKS ┌───[February 1992]──┐ ┌────────────────[ EDIT BATCH CHECK RECORD - FULL SCREEN EDIT ]──────────────┐ │ CHECKNO: 1230 │ │ ACCTNUM: 12345-909090 │ │ NUMBER: 1 │ │ AMOUNT: 340.00 │ │ NAME: ACME JAR │ │ WHATFOR: 12345,1029,93903 │ │ DATE: 11/02/89 │ │ JOURNAL: 110 │ │ ACCOUNT: XAD │ │ CV: F │ │ TYPE: │ │ CFORMAT: │ └────────────────────────────────────────────────────────────────────────────┘ Press Esc to Abort, PgUp/PgDn to Save and Exit DAYO AP, TJS LAB Page: 35 ■ PRINT BATCH CHECKS DRAFT This routine provides you a means of printing checks onto plain paper, in the same format as if they were printed onto the special check forms. Since no posting of the data is done, you can run this option as many times as you wish. ╔═════════════════════════════════════════════════╗ ║ PRINT BATCH CHECKS DRAFT ║ ║ This routine will print a DRAFT for each Batch ║ ║ Check (on normal paper). Review this printout ║ ║ before you print the actual checks! ║ ║ ║ ║ Enter Checking Account Number: 1 ║ ║ ║ ║ Enter Check Format Number: 1 ║ ║ ║ ║ Enter Beginning Check Number: 10000 ║ ║ Checkno Name Amount ║ ║ 10000 JOHN DOE 100.00║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ╟────────────────┬────────────────┬───────────────╢ ╟████████████████████████████████████████████████─╢ ╚════════════════╧════════════════╧═══════════════╝ Standby While I Print The Draft Batch Checks! Checks Total: 100.00 DAYO AP, TJS LAB Page: 36 ■ PRINT BATCH CHECKS DRAFT Run this option when you are very sure that you want to print the final check data (from the database TCHECKS.DBF). The printing and posting progress is displayed by the display of the Check number, Payee, and Amount, a graph, and the database getting data posted to it. It is critical that this process is not interrupted! DAYO AP Version 4.0 TJS LAB CHECKS ┌───[February 1992]──┐ ╔══════════════════════════╗ │S M T W T F S │ ╔════════════════════════════════════════════════╗▄ ├────────────────────┤ ║ PRINT BATCH CHECKS & POST ! ║█░ │ 1 2 3 4 5 6 7│ ║This routine prints your Batch Checks, and Posts║█░ │ 8 9 10 11 12 13 14│ ║the check amounts to the vendor/customer record.║█░ │15 16 17 18 19 20 21│ ║Verify/browse the Batch Checks before printing! ║█░ │22 23 24 25 26 27 28│ ║ ║▀ │29 30 │ ║ Enter Checking Account Number: 1 ║ │ │ ║ ║ └────────────────────┘ ║ Enter Check Format Number: 1 ║─────────────────────────╖ ║ ║ ║ ║ Enter Beginning Check Number: 10000 ║─────────────────────────╢ ║ Checkno Name Amount ║ RECORDS SIZE ║ ║ 10000 JOHN DOE 100.00║─────────────────────────╢ ║ ║╔══════════════════════════╗ ║ ║║POSTING & PRINTING PROG. ║ ║ ║╟──────────────────────────╢ ║ ║║ Vendor/Customer Record ║ ║ ║║»─>AP Header/AR Receipts ║ ║ ║║ Check Register ║ ╟────────────────┬────────────────┬──────────────╢║ Checking Account Bal. ║ ╟████████████████████████████████████████████████╢║ Printing Check ║ ╚════════════════╧════════════════╧══════════════╝╚══════════════════════════╝ Standby While I Print & Post The Batch Checks! Checks Total: 100.00 DAYO AP, TJS LAB Page: 37 ■ BROWSE RECURRING CHECKS All Recurring Checks must be added to the database RECHECK.DBF before a check can be printed in the batch mode. This 'colorful' browse routine displays a facsimile of the Recurring Check atop the screen. DAYO AP Version 4.0 TJS LAB CHECKS ┌───[February 1992]──┐ ╔████████████████████████████████████████████████████████████████████████████│ ║█░TJS LAB░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░█┤ ╟█░░░░░░░░░░░░░Bank Orlando National Bank ░░░░░░░░░░# 1232░░░░░░░░█│ ║█░Pay Two Hundred Forty-Three Dollars & Thirty-Seven Cents░░░░░░░░░░░░░░░░░█│ ║█░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░ID░░░░░░░░░░Date░░░░░░Amount░░░░░░░░█│ ║█░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░ACME JAR ░░03/04/90░░$******243.37░█│ ║█░To The JOHN SMITH ░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░█│ ║█░ Order PO BOX 10000 ░░░░░For Yacht █│ ║█░ Of ░░░░░░░░░░░░░░░░░░░░BIMONTH ░░░░░░█┘ ║█░░░░░░░░HOUSTON, TX 90900 ░░░░░░░░░░░░░░░░Due Now!░░░░░░░░█ ║████████████████████████████████████████████████████████████████████████████ ╟┌──────────────────────────────────────────────────────────────────────────┐ ║│ Number 1 Account # 24 234 23 Check Format 1 Vendor Check │ ╚└──────────────────────────────────────────────────────────────────────────┘ ╔════════════════════════[ BROWSE RECURRING CHECKS ]═══════════════════════╗ ║ RECURRING NAME VE LASTDATE SCHEDULE ║ ║────────────╥────────────────────────────────╥────╥──────────╥────────────║ ║ 2 ║ JOHN SMITH ║ T ║ 02/01/90 ║ BIMONTH ║ ║ 3 ║ ACME JARS ║ T ║ 11/11/11 ║ MIDMONTH ║ ╚══════════════════════════════════════════════════════════════════════════╝ Esc (Exit) F1 (* Help *) F2 (Edit) Ctrl U (Delete) Ctrl N (Add) Ctrl F1 (Mark Print) Ctrl F2 (UnMark Print) Alt F1 (Summary) Find: F5 (RECURRING) F6 (NAME) F7 (SCHEDULE) F8 (ACCOUNT) ■ SCHEDULE CODES When you add/create a new Recurring Check record, always enter the Schedule Code that determines the frequency that a check be made. Valid Schedule Codes are: SUNDAY Only on a Sunday MONDAY Only on a Monday TUESDAY Only on a Tuesday WEDNESDAY Only on a Wednesday THURSDAY Only on a Thursday FRIDAY Only on a Friday SATURDAY Only on a Saturday MM/DD/YY On a Specific Date (ie: '01/31/91' for January 31, 1992) DAYSxxx Every Few Days, (ie: 'DAYS 21' for every 21 days) SEMIMONTH Every 2 Weeks MIDMONTH Mid Month EOM End of Month BEGMONTH Beginning of the Month BIMONTH Every 2 Months (60 Days) QUARTERLY Every Quarter (90 Days) ANNUAL Once a Year DAYO AP, TJS LAB Page: 38 ■ BROWSE RECURRING CHECKS - FULL SCREEN EDIT Press F2 for a Full Screen Edit: DAYO AP Version 4.0 TJS LAB CHECKS ┌───[February 1992]──┐ ┌──────────────[ EDIT RECURRING CHECK RECORD - FULL SCREEN EDIT ]────────────┐ │ RECURRING: 2 ZIP: 30909 │ │ NAME: JOHN SMITH PHONE: (407) 295-1704 │ │ VE: T DATE: 03/06/90 │ │ LASTDATE: 03/01/90 COMMENT: CODE NAME CASEY │ │ SCHEDULE: MIDMONTH CFORMAT: 1 │ │ PRINT: T │ │ ACCOUNT: ACME JAR │ │ WHATFOR: TRAVEL EXPENSES │ │ TYPE: KGB │ │ AMOUNT: 5000.00 │ │ SUBTOTAL: 0.00 │ │ TAXES: 0.00 │ │ FREIGHT: 0.00 │ │ ADJUST: 0.00 │ │ TOTALPAID: 349000.00 │ │ ACCTNUM: 12345-909090 │ │ NUMBER: 1 │ │ ADDR1: PO BOX 10000 │ │ ADDR2: │ │ CITY: AUGUSTA │ │ STATE: GA │ └────────────────────────────────────────────────────────────────────────────┘ Press Esc to Abort, PgUp/PgDn to Save and Exit DAYO AP, TJS LAB Page: 39 ■ MARK/UNMARK FOR PRINTING Press Ctrl F1 to locate and mark all Recurring Checks that are payable. All Recurring Check records that are found payable, will be marked ready to be printed by setting the PRINT field to true (.T.). You can override the printing by editing this field. When you select this option, you must select the Check Printing Format code. Note, only 1 code can be used for a batch print run... Press Ctrl F2 to UNMARK ALL all Recurring Check records. DAYO AP Version 4.0 TJS LAB CHECKS ┌───[February 1992]──┐ ╔████████████████████████████████████████████████████████████████████████████│ ║█░TJS LAB░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░█┤ ╟█░░░░░░░░░░░░░Bank Orlando National Bank ░░░░░░░░░░# 23400░░░░░░░░█│ ║█░Pay Thirty-Four Dollars & Zero Cents░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░█│ ║█░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░ID░░░░░░░░░░Date░░░░░░Amount░░░░░░░░█│ ║█░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░ACME JAR ░░11/08/89░░$*******34.00░█│ ║╔══════════════════════════════════════════════════════════════════════════╗│ ║║*** Note, only 1 check format can be printed at once... ║│ ║║ ║┘ ║║Enter Check Format Number: 3 ║ ║║ ║ ╟║Check Format Selected: 3/NEBBS RADIO SHACK CHECK ║ ║╚══════════════════════════════════════════════════════════════════════════╝ ╚└──────────────────────────────────────────────────────────────────────────┘ ╔════════════════════════[ BROWSE RECURRING CHECKS ]════════════════════════╗ ║ RECURRING NAME VE LASTDATE SCHEDULE ║ ║────────────╥────────────────────────────────╥────╥──────────╥─────────────║ ║ 2 ║ JOHN SMITH ║ T ║ 02/01/90 ║ BIMONTH ║ ║ 3 ║ ACME JARS ║ T ║ 11/11/11 ║ MIDMONTH ║ ╚═══════════════════════════════════════════════════════════════════════════╝ Esc (Exit) F1 (* Help *) F2 (Edit) Ctrl U (Delete) Ctrl N (Add) Ctrl F1 (Mark Print) Ctrl F2 (UnMark Print) Alt F1 (Summary) Find: F5 (RECURRING) F6 (NAME) F7 (SCHEDULE) F8 (ACCOUNT) Standby while I mark Due checks! (Set PRINT field to .T.) DAYO AP, TJS LAB Page: 40 ■ RECURRING CHECK SUMMARY Press Alt F1 to list the Recurring Checks that are 'printable' onto the screen: ╔════════════[ RECURRING CHECK SUMMARY ]═══════════════╗ ║Name Amount Subtotal║ ║JOHN SMITH 34.00 277.37║ ║ANDY ANDREW ALTIZER, INC. 243.37 243.37║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ╚══════════════════════════════════════════════════════╝ 2/3 ■ PRINT RECURRING CHECKS DRAFT This routine will print the Recurring Checks onto plain/regular paper. Use this option to insure the accuracy of the data and format of the Recurring Checks BEFORE the final step of 'Print & Post Recurring Checks'. ╔═════════════════════════════════════════════════╗ ║ PRINT RECURRING CHECKS DRAFT ║ ║ This routine will print a DRAFT check for each ║ ║ Recurring Check. Review the printout before ║ ║ you print the actual checks! ║ ║ ║ ║ Enter Checking Account Number: 1 ║ ║ ║ ║ Enter Check Format Number: 3 ║ ║ ║ ║ Enter Beginning Check Number: 10000 ║ ║ Checkno Name Amount ║ ║ 10000 JOHN DOE 3100.00║ ║ 10001 JANE DOE 4100.00║ ║ 10002 MARY DOE 5100.00║ ║ 10003 JOSE DOE 4650.00║ ║ 10004 HANK DOE 70.00║ ║ ║ ╟────────────────┬────────────────┬───────────────╢ ╟█████████████████████████████████████████────────╢ ╚════════════════╧════════════════╧═══════════════╝ Standby While I Print The Draft Recurring Checks! Checks Total: 17020.00 DAYO AP, TJS LAB Page: 41 ■ PRINT & POST RECURRING CHECKS This routine is the FINAL step in the printing of Recurring Checks. ╔═════════════════════════════════════════════════╗ ║ PRINT & POST RECURRING CHECKS ║ ║ This routine will print and post recurring ║ ║ checks. Use with caution! ║ ║ ║ ║ Enter Checking Account Number: 1 ║ ║ ║ ║ Enter Check Format Number: 3 ║ ║ ║ ║ Enter Beginning Check Number: 35 ║ ║ Checkno Name Amount ║ ║ 10000 JOHN DOE 3100.00║ ║ 10001 JANE DOE 4100.00║ ║ 10002 MARY DOE 5100.00║ ║ 10003 JOSE DOE 4650.00║ ║ 10004 HANK DOE 70.00║ ╟────────────────┬────────────────┬───────────────╢ ╟████████████████████████████████─┼───────────────╢ ╚════════════════╧════════════════╧═══════════════╝ Standby While I Print The Recurring Checks! Checks Total: 17020.00 ■ HAND CHECKS A Hand/Manual Check is created with this routine. Respond to 4 prompts for: Vendor, Customer, or Miscellaneous Expense number Checking Account Number Check Format Number Check Number ╔════════════════[ MANUAL 'HAND' CHECKS ]════════════════╗ ║█ █ █ █ █ █ █ █ █ ███ █ █ ███ ███ █ █ ███║ ║██ ██ █▀█ ██ █ █ █ █▀█ █ █ █ █ █ █ █▄█▀ █ ║ ║█████ █ █ ████ █ █ █ █ █ █ ███ ██ █ ██▄ ███║ ║█ █ █ █▀▀▀█ █ ██ █ █ █▀▀▀█ █ █ █ █ █ █ █ █▄ █║ ║█ █ █ █ █ █ ███ █ █ ██ ███ █ █ ███ ███ █ █ ███║ ╟────────────────────────────────────────────────────────╢ ║ Use this routine to create and print 'Hand' Checks to ║ ║ make a payment for a vendor, miscellaneous expenses, ║ ║ or a customer/client (ie: refund). ║ ║ Hand checks provide a simple means of paying your ║ ║ payables 'one at a time' or individually... ║ ║ ║ ║ Create a hand check for a VENDOR ║ ║ VENDOR: ACME JAR, JOHN SMITH ║ ║ Enter Checking Account Number: 1 ║ ║ Enter Check Format Number: 1 ║ ║ Enter Check Number: 32 ║ ╚════════════════════════════════════════════════════════╝ DAYO AP, TJS LAB Page: 42 ■ SELECT ACCOUNT TYPE The first prompt is for the type of account, Vendor (AP), Customer (AR), or Miscellaneous Expense (AP). This selection is required so that the amount of the check can be applied to the appropriate databases. If the Vendor, Customer, or Miscellaneous Expense number is not known, then a browse of the select check type will appear onto the screen as shown below for Vendors: DAYO AP Version 3.21 TJS LAB HAND CHECKS ┌───[February 1992]──┐ ╔════════════════[ MANUAL 'HAND' CHECKS ]══════════════╗│S M T W T F S │ ║█ █ █ █ █ █ █ █ █ ███ █ █ ███ ██ █ █ ██║├────────────────────┤ ║██ ██ █▀█ ██ █ █ █ █▀█ █ █ █ █ █ █ █▄█▀ █ ║│ 1 2 3 4 5 6 7│ ║█████ █ █ ████ █ █ █ █ █ █ ███ ██ █ ██▄ ██║│ 8 9 10 11 12 13 14│ ║█ █ █ █▀▀▀█ █ ██ █ █ █▀▀▀█ █ █ █ █ █ █ █ █▄ █║│15 16 17 18 19 20 21│ ║█ █ █ █ █ █ ███ █ █ ██ ███ █ █ ███ ██ █ █ ██║│22 23 24 25 26 27 28│ ╟──────────────────────────────────────────────────────╢│29 30 │ ║ Use this routine to create and print 'Hand' Checks to║│ │ ║ make a payment for a vendor, miscellaneous expenses, ║└────────────────────┘ ║ or a customer/client (ie: refund). ║──────────────────╖ ║ Hand checks provide a simple means of paying your ║ ║ ║ payables 'one at a time' or individually... ║──────────────────╢ ║ ║ RECORDS SIZE ║ ║ Create a hand check for a VENDOR ║──────────────────╢ ║ Enter VENDOR Number: ║ 22 9K ║ ║┌─────────────────────────────[ Select VENDOR ]─────────────────────────────┐ ║│VENDOR NAME ADDR1 │ ║│───────────╥────────────────────────────────╥──────────────────────────────│ ║│ACME JAR ║ JOHN SMITH ║ PO BOX 10000 │ ║│RD ║ RON DAVIDSON, INC ║ 1900 MAURY ROAD │ ║│TJS LAB ║ TJS LAB ║ PO BOX 585366 │ ║└───────────────────────────────────────────────────────────────────────────┘ Esc (Exit) F1 (Help) Find: F5 (VENDOR) F6 (NAME) ■ FINAL HAND CHECK EDIT After passing through the first 4 prompts, you will get one last chance to make any final edits to the Hand Check. There are 5 final edit prompts: The Payee can be changed from the default For/Reason For the check Amount Check Type Date DAYO AP, TJS LAB Page: 43 A facsimile of the Hand Check is displayed atop the screen during this process: DAYO AP Version 4.0 TJS LAB HAND CHECKS ┌───[February 1992]──┐ ╔████████████████████████████████████████████████████████████████████████████│ ║█░TJS LAB░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░█┤ ╟█░░░░░░░░░░░░░░░░░░Your Banks Name░░░░░░░░░░░░░░░░░░░░░░░░░Check # 32░░░░░░█│ ║█░Pay ░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░█│ ║█░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░ID░░░░░░░░░░Date░░░░░░Amount░░░░░░░░█│ ║█░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░ACME JAR░░░░04/04/90░░ 100.00░░░░░░█│ ║█░To The JOHN SMITH ░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░█│ ║█░ Order PO BOX 10000 ░░░░░For ░░░░░░░░░░░░░░░░░░░░░░░░░░░█│ ║█░ Of ░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░█┘ ║█░░░░░░░░WESTVILLE, ST 55555 ░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░█ ║████████████████████████████████████████████████████████████████████████████ ║┌──────────────────────────────────────────────────────────────────────────┐ ║│ Number 1 Account # Checking Account # Check Format 1/NEBBS RADIO SHACK│ ║└──────────────────────────────────────────────────────────────────────────┘ ║╔════════════════════════ ENTER THE HAND CHECK DATA ]══════════════════════╗ ║║ All of the following prompts must be completed before a check can be ║ ║║ completed/Printed. ║ ║║ To The Order Of: JOHN SMITH ║ ║║ For: Special Things... ║ ║║ Amount: 100.00 ║ ║║ Check Type: XXX ║ ║║ Date: 04/04/90 ║ ╚╚══════════════════════════════════════════════════════════════════════════╝ Esc (Exit) Press PgDn/PgUp or enter/return through all the prompts to continue... ■ APPLY TOWARDS MULTIPLE GL ACCOUNTS/ENTRIES At this point you have the option to applying the amount of the check into multiple GL Account Entries. Use this option if you are using DAYO General Ledger (GL) and want to apply the amount of a check towards more than one GL Account/Entry. ┌──────────────────────────────────────────────────────────────────────────┐ │ Do you wish to apply this Check Amount to multiple GL Entries? (Y/N) │ └──────────────────────────────────────────────────────────────────────────┘ If you selected Y (Yes) to the GL Entries prompt, you will be prompted to enter a valid GL Class Code and the amount you wish to apply towards that Class Code (corresponds to a GL Account/Entry). DAYO AP, TJS LAB Page: 44 ┌────────────────────────────────────────────────────────────────────────────┐ │ Total Amount: 1000.00 Class: AP Amount: 800.00 │ │ Enter Class Code & Amount -> AP 800.00 │ │ You can divide up the amount AP1 200.00 │ │ (as shown to the upper right) │ │ to not more than 50 Class Codes. │ │ You must continue until the │ │ amount is totally applied... │ │ The Last Class Code should be │ │ the initial one... │ │ │ └────────────────────────────────────────────────────────────────────────────┘ ■ APPLY TOWARDS AP PO/PAYABLE RECORDS If the Manual/Hand check was for a vendor, you will be prompted to apply the amount of the check towards open AP payable records (APH.DBF). You apply the amount of the check towards the payable records. The balance of the check amount is automatically reduced until it is fully applied. ╔══════[ Apply Total Amount (1000.00) of Check To PO/Invoice/Payable ]═══════╗ ║JOURNAL PO VENDOR NAME AMOUNT ║ ║────────╥────────╥────────────╥────────────────────────────────╥────────────║ ║ 100039 ║ 61001 ║ TLJ ║ TOM JOHNSON ║ 332.00 ║ ║ 100040 ║ 61021 ║ TLJ ║ TOM JOHNSON ║ 60.00 ║ ║ 100041 ║ 61042 ║ TLJ ║ TOM JOHNSON ║ 332.00 ║ ║ 100042 ║ 61013 ║ TLJ ║ TOM JOHNSON ║ 358.00 ║ ║ 100043 ║ 61014 ║ TLJ ║ TOM JOHNSON ║ 1984.00 ║ ║ 100049 ║ 62023 ║ TLJ ║ TOM JOHNSON ║ 10.00 ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit) Enter (Apply to PO/Invoice/Payable) Find: F5 (PO) F6 (Name) F7 (Vendor Number) F8 (Journal Number) When applying a check to an open payable, you will be prompted to enter an amount not to exceed the amount due: ╔═════════════════════════════════════════════════════════════════════╗ ║ PO: 1003 ║ ║ Journal: 100041 ║ ║ Vendor: TLJ ║ ║ Name: TOM JOHNSON ║ ║ Date: 09/20/90 ║ ║ Amount: 332.00 ║ ║ (-) Apply Amount: 332.00 ║ ╚════[ Balance: 1000.00 ]═════════════════════════════════════════════╝ When finished, a prompt will appear to press C to continue, or Esc to abort the check: ┌───────────────────────────────────────────────────────────┐ │ Ready your printer (LPT1). ▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀ │ │ Press C to continue, or Esc to abort... │ └───────────────────────────────────────────────────────────┘ DAYO AP, TJS LAB Page: 45 ■ POSTING There are 2 options in this routine; the Post of Purchase Orders to the databases APH.DBF and APD.DBF, and the resetting of the Balance Due for all Vendors. AP POST ╔════════════════════════════════════════════════════════════════════════════╗ ║ DAYO ACCOUNTS PAYABLE POST & VENDOR BALANCE DUE RESET/RECALCULATE ║ ╟────────────────────────────────────────────────────────────────────────────╢ ║ 1 - POST TO AP FILES ║ ║ This job will perform the following: ║ ║ ║ ║ Move, Post, & Clear Purchase Order Receipts (RECEIVERS) from the REC.DBF ║ ║ into the APH & APD databases. ║ ║ Computes an amount to be paid to the vendor when/if you run Batch Checks. ║ ╟────────────────────────────────────────────────────────────────────────────╢ ║ 2 - RESET BALANCE DUE ON ALL VENDORS ║ ║ This job will reset/recalculate the 'Balance Due' for each vendor. ║ ║ It will reset the DUE & PAID fields in the database VENDORS.DBF. ║ ║ The DUE field is computed as the sum of (SUBTOTAL+TAXES+ADJUST+FREIGHT) ║ ║ minus the PAID amount for all OPEN records in the database POH.DBF. ║ ║ The PAID field is computed as the sum of the PAID amount for all OPEN ║ ║ records in the database POH.DBF. Also, all open credit records found in ║ ║ the database APH.DBF will be summed and added to the PAID field. ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit) Enter/Return (Select Option) ■ POST TO AP FILES The progress of the AP Post is displayed onto the screen: AP POST ╔══════════════════════════════════════════════════════════════════════════════ ║ DAYO ACCOUNTS PAYABLE POST & VENDOR BALANCE DUE RESET/RECALCULATE ╟────────────────────────────────────────────────────────────────────────────── ║ 1 - POST TO AP FILES ║ This job will perform the following: ║ ║ Move, Post, & Clear Purchase Order Receipts (RECEIVERS) from the REC.DBF ║ into the APH & APD databases. ║ Computes an amount to be paid to the vendor when/if you run Batch Checks. ╟────────────────────────────────────────────────────────────────────────────── ║ ║ 0 Records 53 106 ║ ╔════════════════╦══════════════════╦═════════════════╦════════════════╗ ║ ╠██████████████████████████████████████████████═══════╬════════════════╣ ║ ╠════════════════╩══════════════════╬═════════════════╩════════════════╣ ║ 0% Completed 50% Done! ║ Receiver: 22 Record: 70 ║ ║ Standby while I do the AP POST! ╚══════════════════════════════════════════════════════════════════════════════ DAYO AP, TJS LAB Page: 46 ■ EXPANDED EXPLANATION OF AP POSTING AP Posting is a term used to denote the 'closing' of Purchase Orders that have been received into inventory (using the RECEIVE option in DAYO Inventory), as well as the process of 'paying off' (usually by a check) of the AP payable records (found in APH.DBF). Running the AP POST routine creates AP Payable records/invoices based on Purchase Orders that have been received, and hence ready to be 'paid off'. A 'copy' of the Purchase Order is created in the databases APH.DBF and APD.DBF and the Purchase Order records (in PO.DBF and POD.DBF) are deleted if completely received. The posting process is driven by data found in the receiving database (REC.DBF). You can create AP Payable records 'manually', by pressing Ctrl N while in the AP Header Record Browse routine (in AP BROWSE). The amount of the AP Payable is to be found/placed in the field 'AMOUNT' in the database APH.DBF. AP Payables (APH.DBF) records are deemed open when the field 'OPEN' is set to .T. (true) and the field 'PC' (Purchase Cleared) is set to .F. (false). The payables are automatically closed via some of the check writing routines (ie: Batch Checks & Vendor Manual/Hand Checks), but can be closed 'manually' by editing the OPEN & PC fields setting them to: OPEN = .F., and PC = .T. Everytime you write/print a check, a record of the transaction is recorded in the database CHECKS.DBF. It is often necessary to use the check writing capability to 'close' payables. The Batch Checks routine computes a check amount for each vendor you owe money to. This is determined by the presence of open payable records (in APH.DBF) with a PAYDATE less than or equal to today's date. When/if a Batch Check is printed, the amount on the check is 'applied' to all the payables that 'made up' that amount, automatically closing any payables that have been 'paid off'. The printing of a Manual/Hand Check for a vendor does pretty much the same thing, except that you get to decide which payable record(s) are to be 'applied to' with the amount of the check. AP Payables with a negative value denotes a CREDIT for a vendor. Though DAYO supports expenses and recurring expenses, it is recommended that a vendor record be created for any/all expenses (ie: Electric Bill, Mortgage, Rents, Shipping/UPS, MISC expense, and Employees that are reimbursed). It makes 'things' simpler if all your expenses have a vendor record. DAYO AP, TJS LAB Page: 47 ■ AP POSTING FLOWCHART Create a PO (in DAYO Inventory) ┌───────────┐ ┌───────────┐ │ Purchase │ │ PO │ Receiving routine found │ Orders ├───────────>│ Received │ in DAYO Inventory │ (PO.DBF ├────────┐ │ (REC.DBF) │ │ & POD.DBF)│ │ └┬──────────┘ └───────────┘ │ └─>>─┐ │ ┌─────┴───┐ AP Posting found in DAYO AP └──>│ AP Post │ └┬────────┘ ┌───>>>>──────────┐ └──>>─┐ │ ┌─────┴──────┐ AP Payables ┌──────┴───────────┴──┐ │ Reports: │ found and │ AP Payables │ │■ AP Ageing │ maintained in │ (APH.DBF & APD.DBF) │ │■ AP Headers│ DAYO AP └─┬───────────────────┘ │■ AP Detail │ (AP BROWSE) └──>>──┐ └────────────┘ ┌────────┴───────────────────────┐ │ Close ('pay off') Payables │ │ (OPEN = .F., PC = .T. ) │ │■ Batch Checks │ │■ Manual/Hand Checks │ │■ Manual Close (Browse APH.DBF) │ └────────────────────────────────┘ ■ VENDOR BALANCE DUE RESET/RECALCULATE The progress of the Vendors Balance Reset is displayed onto the screen, as is the total Accounts Payable amount when it is finished! AP POST ╔════════════════════════════════════════════════════════════════════════════╗ ║ DAYO ACCOUNTS PAYABLE POST & VENDOR BALANCE DUE RESET/RECALCULATE ║ ╟────────────────────────────────────────────────────────────────────────────╢ ║ 0 Records 7 14 ║ ║ ╔════════════════╦══════════════════╦═════════════════╦════════════════╗ ║ ║ ╠██████████████████████████████████████████████████████████████████████╣ ║ ║ ╠════════════════╩══════════════════╬═════════════════╩════════════════╣ ║ ║ 0% Completed 50% Done!║ ║ Done! Total Account Payable: 107406.60 ║ ╟────────────────────────────────────────────────────────────────────────────╢ ║ 2 - RESET BALANCE DUE ON ALL VENDORS ║ ║ This job will reset/recalculate the 'Balance Due' for each vendor. ║ ║ It will reset the DUE & PAID fields in the database VENDORS.DBF. ║ ║ The DUE field is computed as the sum of (SUBTOTAL+TAXES+ADJUST+FREIGHT) ║ ║ minus the PAID amount for all OPEN records in the database POH.DBF. ║ ║ The PAID field is computed as the sum of the PAID amount for all OPEN ║ ║ records in the database POH.DBF. Also, all open credit records found in ║ ║ the database APH.DBF will be summed and added to the PAID field. ║ ╚════════════════════════════════════════════════════════════════════════════╝ DAYO AP, TJS LAB Page: 48 ■ REPORTS The AP Reports menu is displayed onto the left side of the screen: DAYO AP Version 4.0 TJS LAB REPORTS ┌───[February 1992]──┐ ╔═════════════════════════╗ │S M T W T F S │ ║ AP REPORTS ║████▄ ▄█▄ █░ █░ ▄███▄ ├────────────────────┤ ╟─────────────────────────╢█░ █░ █░█░ █░ █░ █░ █░ │ 1 2 3 4 5 6 7│ ║ AP Summary ║█░ █░ █░█░ ▀█░██░ █░ █░ │ 8 9 10 11 12 13 14│ ║ Purchase Order Headers ║█░ █░ █▀▀▀█░ ▀█▀ █░ █░ │15 16 17 18 19 20 21│ ║ Purchase Order Details ║█░ █░ █░ █░ █░ █░ █░ │22 23 24 25 26 27 28│ ║ Vendors ║████▀ █░ █░ █░ ▀███▀ │29 30 │ ║ Vendor Mailing Labels ║ │ │ ║ Vendor Folder Labels ║ └────────────────────┘ ║ Checking Accounts ║╓────────────────────────────────────────────────╖ ║ AP Check Register ║║ DAYO AP STATISTICS ║ ║ Check Formats ║╟────────────────────────────────────────────────╢ ║ Recurring Checks ║║ DATABASE NAME RECORDS SIZE ║ ║ Check Listing ║╟────────────────────────────────────────────────╢ ║ Deposits ║║ POH.DBF PO Headers 22 9K ║ ║ 1099 Summary ║║ POD.DBF PO Detail 38 5K ║ ║ Misc Expenses ║║ APH.DBF AP Header 59 26K ║ ║ Inventory Expanded ║║ APD.DBF AP Detail 154 20K ║ ║ Inventory Adjustments ║║ VENDORS.DBF Vendors 14 5K ║ ║ Inventory Receivers ║║ EXPENSES.DBF Misc Expenses 7 1K ║ ║ Uncleared Receivers ║║ CHECKS.DBF Check Register 39 7K ║ ╟─────────────────────────╢║ DEPOSITS.DBF Deposits 22 3K ║ ║ Select Option ║╚════════════════════════════════════════════════╝ ╚═════════════════════════╝ ■ REPORTS LIST There are 28 AP reports/routines to select from: AP Summary Deposits Purchase Order Headers 1099 Summary Purchase Order Details Misc Expenses Vendors Inventory Expanded Vendor Mailing Labels Inventory Adjustments Vendor Folder Labels Inventory Receivers Checking Accounts Uncleared Receivers AP Check Register Uncleared AP Headers Check Formats Purchase Clearing REC Recurring Checks Purchase Clearing APH Check Listing Configuration Settings AP Detail Printer Setup/Drivers Payables Ageing AP Headers Reprint Checks View Reports On Screen DAYO AP, TJS LAB Page: 49 ■ ACCOUNTS PAYABLE SUMMARY The Accounts Payable Summary is a 5 part report: Accounts Payable Deposits Checks Accounts Balances Expenses ╔════════════════════════════════════════════════════════╗ ║ Accounts Payable Summary ║ ║ ║ ║ The Accounts Payable Summary is a 4 part report: ║ ║ 1. Accounts Payable ║ ║ 2. Deposits ║ ║ 3. Checks ║ ║ 4. Accounts Balances ║ ║ 5. Expenses ║ ║ ║ ║ Start Date: 03/05/90 Ending Date: 04/04/90 ║ ║ ║ ║ ║ ║ ║ ║ Send Output to Printer? (Y/N) ( No -> To File) ║ ║ ║ ║ Enter File Name: APSUM.txt ║ ║ ║ ║ Enter Report Title: TJS LAB ║ ║ ║ ╚════════════════════════════════════════════════════════╝ ■ PAYABLES SUMMARY (APH.DBF) ╔════════════════════════════════════════════════════════╗ ║ Accounts Payable Summary ║ ║ Payables Summary (APH.DBF) ║ ║ ║ ║ Purchase Cleared: 10 ║ ║ Not Purchase Cleared: 30 ║ ║ PC Amount: 35196.34 ║ ║ Not PC Amount: 14251.14 ║ ║ ║ ║ Open: 31 ║ ║ Closed: 9 ║ ║ Open Amount: 8785.29 ║ ║ Closed Amount: 29730.49 ║ ║ ║ ║ Purchase Orders Summary (POH.DBF) ║ ║ ║ ║ Open Purchase Orders: 10 ║ ║ Open Purchase Orders Amount: 35196.34 ║ ║ ║ ╚════════════════════════════════════════════════════════╝ DAYO AP, TJS LAB Page: 50 ■ DEPOSITS SUMMARY (DEPOSITS.DBF) ╔════════════════════════════════════════════════════════╗ ║ Accounts Payable Summary ║ ║ Deposits Summary (DEPOSITS.DBF) ║ ║ ║ ║ # Account # Amount ║ ║ Totals 953.26 ║ ║ 1 12345-909090 43.33 ║ ║ 2 2939-2929-002 909.93 ║ ║ ║ ║ ║ ║ ║ ║ ║ ╚════════════════════════════════════════════════════════╝ ■ CHECKS SUMMARY (CHECKS.DBF) Note, the Check # is only a 'marker' to let you know the first number for the period of the report. ╔════════════════════════════════════════════════════════╗ ║ Accounts Payable Summary ║ ║ Checks Summary (CHECKS.DBF) ║ ║ ║ ║ Check # # Account # Amount ║ ║ Totals 43097.46 ║ ║ 32 1 12345-909090 100.00 ║ ║ 324 1 12345-909090 12454.34 ║ ║ 546 1 12345-909090 30523.12 ║ ║ 678 1 12345-909090 10.00 ║ ║ 703 1 12345-909090 10.00 ║ ║ ║ ║ ║ ║ ║ ╚════════════════════════════════════════════════════════╝ ■ ACCOUNT BALANCES (ACCOUNTS.DBF) ╔════════════════════════════════════════════════════════╗ ║ Accounts Payable Summary ║ ║ Account Balances (ACCOUNTS.DBF) ║ ║ ║ ║ # Account # Balance ║ ║ Totals 71257.87 ║ ║ 1 12345-909090 -4.00 ║ ║ 2 1234-000202 71261.87 ║ ║ ║ ║ ║ ╚════════════════════════════════════════════════════════╝ DAYO AP, TJS LAB Page: 51 ■ MISCELLANEOUS EXPENSES SUMMARY (EXPENSES.DBF) The Miscellaneous Expenses Summary Report requires a unique index on the TYPE field: ┌──────────────────────────────────────────────────────────┐ │ Database Name: EXPENSES.DBF │ │ Index Name: EXPTYPE.NTX │ │ Number of Records: 7 │ │ ┌──────────────────────────────────────────────────┐ │ │ │███████████████████████████████████████ │ │ │ └──────────────────────────────────────────────────┘ │ │ 0 ─ 10 ─ 20 ─ 30 ─ 40 ─ 50 ─ 60 ─ 70 ─ 80 ─ 90 ─ 100 % │ └──────────────────────────────────────────────────────────┘ ╔════════════════════════════════════════════════════════╗ ║ Accounts Payable Summary ║ ║ Miscellaneous Expenses Summary (EXPENSES.DBF) ║ ║ ║ ║ Type Amount Taxes ║ ║ Totals 514467.62 354.53 ║ ║ XXX 500000.00 0.00 ║ ║ KGB 1500.01 0.00 ║ ║ CIA 2003.13 7.07 ║ ║ DEA 9032.09 343.03 ║ ║ FBI 932.39 4.43 ║ ║ NIS 1000.00 0.00 ║ ║ ║ ╚════════════════════════════════════════════════════════╝ ■ PURCHASE ORDER HEADER REPORT ┌────────────────────────────────────────────────────────┐ │ The Purchase Order (PO) Header Report lists all Open │ │ and/or Closed POH.DBF records. │ │ │ │ The name of the PO Header Report Form is POH.FRM. │ │ │ │ Select the Index -> PURCHASE ORDER (PO) │ │ VENDOR NAME (NAME) │ │ VENDOR CODE (VENDOR) │ │ │ │ Enter Heading: TJS LAB │ │ │ │ Send Output to Printer? (Y/N) ( No -> To File) │ │ │ │ Enter File Name: POHEADER.TXT │ │ │ │ Select the Option ->Open POs │ │ Closed POs │ │ All POs │ │ Start Date: 03/05/90 Ending Date: 04/04/90 │ └────────────────────────────────────────────────────────┘ DAYO AP, TJS LAB Page: 52 ■ PURCHASE ORDER DETAIL REPORT ┌────────────────────────────────────────────────────────┐ │ The Purchase Order (PO) Detail Report lists all Open │ │ and/or Closed POD.DBF records. │ │ │ │ The name of the PO Detail Report Form is POD.FRM. │ │ │ │ Select the Index -> PURCHASE ORDER (PO) │ │ ITEM (ITEM) │ │ VENDOR CODE (VENDOR) │ │ VENDOR ITEM (VENDITEM) │ │ Enter Heading: TJS LAB │ │ │ │ Send Output to Printer? (Y/N) ( No -> To File) │ │ │ │ Enter File Name: PODETAIL.TXT │ │ │ │ Select the Option ->Open POs (Received <> Ordered) │ │ Closed POs (Received = Ordered) │ │ All POs │ │ Start Date: 03/05/90 Ending Date: 04/04/90 │ └────────────────────────────────────────────────────────┘ ■ VENDORS REPORT ┌────────────────────────────────────────────────────────┐ │ The Vendors Report is a printout of your Vendors.dbf. │ │ │ │ The name of the Vendors Report Form is VENDORS.FRM. │ │ │ │ │ │ Select the Index -> VENDOR CODE (VENDOR) │ │ VENDOR NAME (NAME) │ │ │ │ │ │ Enter Heading: TJS LAB │ │ │ │ Send Output to Printer? (Y/N) ( No -> To File) │ │ │ │ Enter File Name: VENDORS.TXT │ │ │ │ │ │ │ └────────────────────────────────────────────────────────┘ DAYO AP, TJS LAB Page: 53 ■ VENDOR MAILING LABELS (BILLTO/SHIPTO) This report routine prints mailing labels (BILL TO or SHIP TO). ┌────────────────────────────────────────────────────────┐ │ │ │ │ │ BILL TO or SHIP TO Labels? │ │ │ │ (Select the 'Bill To', or 'Ship To' Label Option....) │ │ │ │ │ │ │ └────────────────────────────────────────────────────────┘ ┌────────────────────────────────────────────────────────┐ │ Use this option to print Vendor Ship To labels. │ │ │ │ The Ship To Label is the standard size of 3.5x15/16, │ │ 10 Pitch, 6LPI, and contains the following fields: │ │ SHIPNAME SHIPADDR1 SHIPADDR2 │ │ SHIPCITY SHIPSTATE SHIPZIP │ │ ┌──────────────────────────────┐ │ │ │RON DAVIDSON │ │ │ │1200 LAKELAND ROAD │ │ │ │ │ │ │ │LAKELAND, FL │ │ │ │32608 │ │ │ └──────────────────────────────┘ │ │ │ │ VENDOR │ │ Select Vendor -> RD │ │ HURLEY │ │ ACME JAR │ │ FEEDER-1 │ └────────────────────────────────────────────────────────┘ DAYO AP, TJS LAB Page: 54 ■ VENDOR FOLDER LABELS This report/routine will print folder labels. ┌────────────────────────────────────────────────────────┐ │ Use this option to print Vendor Folder labels. │ │ │ │ The Folder Label is the standard size of 3.5x15/16, │ │ 10 Pitch, 6LPI, and contains the following fields: │ │ VENDOR NAME ATTN PHONE │ │ │ │ ┌──────────────────────────────┐ │ │ │VENDORxxxx │ │ │ │NAMExxxxxxxxxxxxxxxx│ │ │ │ATTNxxxxxxxxxxxxxxxx│ │ │ │PHONExxxxxxxxx │ │ │ │ │ │ │ └──────────────────────────────┘ │ │ │ │ VENDOR │ │ Select Vendor -> RD │ │ ACME JAR │ │ HURLEY-A │ │ RRR │ └────────────────────────────────────────────────────────┘ ■ CHECKING ACCOUNTS REPORT ╔═══════════════════════════════════════════════════════╗ ║The Checking Accounts Report is a list of all your ║ ║Checking Accounts (with current balances). ║ ║ ║ ║ ║ ║ ║ ║Select Index -> Number ║ ║ ║ ║Send Output to Printer? (Y/N) ( No -> To File) ║ ║ ║ ║Enter File Name: ACCOUNTS.TXT ║ ║ ║ ║Enter Report Title: TJS LAB ║ ║ ║ ║ ║ ║ ║ ╚═══════════════════════════════════════════════════════╝ DAYO AP, TJS LAB Page: 55 ■ AP CHECKS REPORTS ╔═══════════════════════════════════════════════════════╗ ║The AP Checks Report is a listing of all your checks. ║ ║Supports a date range... ║ ║ ║ ║ ║ ║ ║ ║Enter Checking Account: ALL ║ ║ ║ ║Start Date: 03/05/90 Ending Date: 04/04/90 ║ ║ ║ ║Select Index -> Journal # ║ ║ ║ ║Send Output to Printer? (Y/N) ( No -> To File) ║ ║ ║ ║Enter File Name: CHECKS.TXT ║ ║ ║ ║Enter Report Title: JOES PIZZA BARS ║ ║ ║ ║ ║ ╚═══════════════════════════════════════════════════════╝ ■ CHECK FORMATS REPORT ╔═══════════════════════════════════════════════════════╗ ║The Check Format Report is a listing of all your ║ ║Check Formats. Note, abbreviations are used in lieu ║ ║of the field names. ║ ║ ║ ║Send Output to Printer? (Y/N) ( No -> To File) ║ ║ ║ ║Enter File Name: CFORMAT.TXT ║ ║ ║ ║Enter Report Title: TJS LAB ║ ║ ║ ║ ║ ║ ║ ║ ║ ╚═══════════════════════════════════════════════════════╝ DAYO AP, TJS LAB Page: 56 ■ RECURRING CHECKS REPORT ╔═══════════════════════════════════════════════════════╗ ║ ║ ║The Recurring Check Report lists all your recurring ║ ║checks. ║ ║ ║ ║ ║ ║Select Index -> Recurring ║ ║ ║ ║Send Output to Printer? (Y/N) ( No -> To File) ║ ║ ║ ║Enter File Name: RECURPT.TXT ║ ║ ║ ║Enter Report Title: TJS LAB ║ ║ ║ ║ ║ ║ ║ ╚═══════════════════════════════════════════════════════╝ ■ CHECK LISTING This report requires a special index on NUMBER+CHECKNO. ┌──────────────────────────────────────────────────────────┐ │ Database Name: CHECKS.DBF │ │ Index Name: MISSCHK.NTX │ │ Index Key: NUMBER+CHECKNO │ │ Number of Records: 206 │ │ ┌──────────────────────────────────────────────────┐ │ │ │██████████████████████████ │ │ │ └──────────────────────────────────────────────────┘ │ │ 0 ─ 10 ─ 20 ─ 30 ─ 40 ─ 50 ─ 60 ─ 70 ─ 80 ─ 90 ─ 100 % │ └──────────────────────────────────────────────────────────┘ DAYO AP, TJS LAB Page: 57 The progress of the report is displayed/scrolled upon the screen: ╔════════════════════════════════════════════════════════════════════════════╗ ║ This report lists all checks in the database CHECKS.DBF by each account. ║ ║ ║ ║ Send Output to Printer? (Y/N) ( No -> To File) ║ ║ ║ ║ Enter File Name: CHECLIST.TXT ║ ║ ║ ║ Enter Report Title: Your Company Name ║ ║ ║ ║ # Account Checkno Amount Date ║ ║ 1 1123-123 1063 ║ ║ 1 1123-123 1062 268.10 02/26/92 ║ ║ 1 1123-123 1061 461.02 02/26/92 ║ ║ 1 1123-123 1060 1221.00 12/09/91 ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit) ■ DEPOSITS REPORTS ╔═══════════════════════════════════════════════════════╗ ║The Deposits Report is a list of all your checking ║ ║account deposits for a selected date range. Default ║ ║range is the past 30 days. You can select 1 or ALL ║ ║checking accounts. ║ ║ ║ ║Enter Checking Account: ALL ║ ║ ║ ║Start Date: 03/05/90 Ending Date: 04/04/90 ║ ║ ║ ║Select Index -> Deposit # ║ ║ ║ ║Send Output to Printer? (Y/N) ( No -> To File) ║ ║ ║ ║Enter File Name: DEPOSITS.TXT ║ ║ ║ ║Enter Report Title: TJS LAB ║ ║ ║ ║ ║ ╚═══════════════════════════════════════════════════════╝ DAYO AP, TJS LAB Page: 58 ■ 1099 MISC FORMS This report routine will print the Federal Form 1099 MISC to your printer or file. ╔════════════════════════════════════════════════════════╗ ║ This report option will print 1099 Misc Forms for ║ ║ Accounts Payable records for a specified TYPE, ║ ║ date range, and ALL or a specific Vendor/AP Account. ║ ║ All data is derived from the database CHECKS.DBF. ║ ║ The printer should be set to 6 LPI & 10 Pitch. ║ ║ ║ ║ Enter Type (Spaces for Any/All Types): 99 ║ ║ Start Date: 04/04/89 Ending Date: 04/04/90 ║ ║ Enter Vendor/Account: ALL ║ ║ Send Output to Printer? (Y/N) ( No -> To File) ║ ║ Enter File Name: 1099.TXT ║ ║ ║ ║ ███░ ▄████▄ ▄███▄█░ ▄███▄█░ ║ ║ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ║ ║ ██░ ██░ ██░ ▀█████░ ▀█████░ ║ ║ ██░ ██░ ██░ ██░ ██░ ║ ║ ██░ ██░ ██░ ██░ ██░ ║ ║ ▄██▄ ▀████▀ ██░ ██░ ║ ╚════════════════════════════════════════════════════════╝ A special index (on ACCOUNT) is created ┌──────────────────────────────────────────────────────────┐ │ Database Name: CHECKS.DBF │ │ Index Name: F1099.NTX │ │ Number of Records: 39 │ │ ┌──────────────────────────────────────────────────┐ │ │ │████████████████████████████████████████ │ │ │ └──────────────────────────────────────────────────┘ │ │ 0 ─ 10 ─ 20 ─ 30 ─ 40 ─ 50 ─ 60 ─ 70 ─ 80 ─ 90 ─ 100 % │ └──────────────────────────────────────────────────────────┘ DAYO AP, TJS LAB Page: 59 The progress of the printing is displayed/scrolled onto the screen: ╔════════════════════════════════════════════════════════╗ ║ ███░ ▄████▄ ▄███▄█░ ▄███▄█░ ║ ║ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ║ ║ ██░ ██░ ██░ ▀█████░ ▀█████░ ║ ║ ██░ ██░ ██░ ██░ ██░ ║ ║ ██░ ██░ ██░ ██░ ██░ ║ ║ ▄██▄ ▀████▀ ██░ ██░ ║ ║ Enter Type (Spaces for Any/All Types): 99 ║ ║ Start Date: 04/04/89 Ending Date: 04/04/90 ║ ║ ║ ║ Enter File Name: 1099.TXT ║ ║ ║ ║ Vendor Name Amount ║ ║ Run Total Federal Form 1099 ----> 12077.34 ║ ║ ACME JAR JOHN SMITH 10000.00 ║ ║ HURLEY HURLEY, INC 0.00 ║ ║ MORGAN-A JOE MORGAN ENTERPRISES 70.00 ║ ║ RD RON DAVIDSON 2007.34 ║ ║ ║ ╚════════════════════════════════════════════════════════╝ ■ MISCELLANEOUS EXPENSES REPORT ╔═══════════════════════════════════════════════════════╗ ║The Miscellaneous Expenses Report lists all MISC ║ ║expenses for a selected date range. Default range ║ ║is the past 30 days. ║ ║ ║ ║Start Date: 03/05/90 Ending Date: 04/04/90 ║ ║ ║ ║Select Index -> Expense # ║ ║ ║ ║Send Output to Printer? (Y/N) ( No -> To File) ║ ║ ║ ║Enter File Name: MISCX.TXT ║ ║ ║ ║Enter Report Title: TJS LAB ║ ║ ║ ║ ║ ╚═══════════════════════════════════════════════════════╝ DAYO AP, TJS LAB Page: 60 ■ EXPANDED INVENTORY REPORT ┌────────────────────────────────────────────────────────┐ │ The Default Expanded Inventory Report (EXPANDED.FRM) │ │ contains the following fields/variables: │ │ ITEM COST │ │ DESC RETAIL │ │ ONHAND PRICE │ │ ONORDER TYPE │ │ VENDITEM CLASS │ │ VENDOR │ │ │ │ Select the Index -> ITEM (ITEM) │ │ DESCRIPTION (DESC) │ │ VENDOR CODE (VENDOR) │ │ VENDOR ITEM (VENDITEM) │ │ TYPE (TYPE) │ │ Enter Heading: EXPANDED REPORT │ │ Send Output to Printer? (Y/N) ( No -> To File) │ │ Enter File Name: EXPANDED.TXT │ │ │ │ │ └────────────────────────────────────────────────────────┘ ■ INVENTORY ADJUSTMENTS ┌────────────────────────────────────────────────────────┐ │ This report prints out all recorded inventory │ │ adjustments for a given date range. │ │ The Report Form Name is INVADJ.FRM and reports │ │ the following fields (from the INVADJ.DBF): │ │ ITEM VENDITEM QTY │ │ COST PRICE RETAIL │ │ DOLLARS REASON DATE │ │ │ │ Enter Heading: TJS LAB │ │ │ │ Send Output to Printer? (Y/N) ( No -> To File) │ │ │ │ Enter File Name: ADJUST.TXT │ │ │ │ │ │ Start Date: 03/05/90 Ending Date: 04/04/90 │ │ │ │ │ └────────────────────────────────────────────────────────┘ DAYO AP, TJS LAB Page: 61 ■ RECEIVING REPORT ┌────────────────────────────────────────────────────────┐ │ The Receiving Report is a printout of your Receivers; │ │ all receipts of your Items. │ │ │ │ The name of the Receiving Report Form is REC.FRM. │ │ │ │ Select the Index -> RECEIVER (KEY │ │ PURCHASE ORDER (PO) │ │ ITEM (ITEM) │ │ VENDOR ITEM (VENDITEM) │ │ Enter Heading: TJS LAB │ │ │ │ Send Output to Printer? (Y/N) ( No -> To File) │ │ │ │ Enter File Name: REC.TXT │ │ │ │ │ │ Start Date: 04/05/85 Ending Date: 04/04/90 │ │ │ └────────────────────────────────────────────────────────┘ ■ UNCLEARED RECEIVERS REPORT ╔════════════════════════════════════════════════════════╗ ║ The Uncleared Receivers Report is 1 of 4 Purchase ║ ║ Clearing Reports for DAYO AP. This reports lists ║ ║ all uncleared receivers (PC=.F.), from the database ║ ║ REC.DBF for a selected date range... ║ ║ ║ ║ Start Date: 03/05/90 Ending Date: 04/04/90 ║ ║ ║ ║ Select Index -> KEY ║ ║ ║ ║ Send Output to Printer? (Y/N) ( No -> To File) ║ ║ ║ ║ Enter File Name: UNPCREC.TXT ║ ║ ║ ║ Enter Report Title: TJS LAB ║ ║ ║ ╚════════════════════════════════════════════════════════╝ DAYO AP, TJS LAB Page: 62 ■ UNCLEARED AP RECORDS REPORT ╔════════════════════════════════════════════════════════╗ ║ The UnCleared AP Records Report is 1 of 4 Purchase ║ ║ Clearing Reports for DAYO AP. This reports lists ║ ║ all uncleared AP Header Records (PC=.F.), from the ║ ║ database APH.DBF for a selected date range... ║ ║ ║ ║ Start Date: 03/05/90 Ending Date: 04/04/90 ║ ║ ║ ║ Select Index -> PO ║ ║ ║ ║ Send Output to Printer? (Y/N) ( No -> To File) ║ ║ ║ ║ Enter File Name: UNPCAPH.TXT ║ ║ ║ ║ Enter Report Title: TJS LAB ║ ║ ║ ╚════════════════════════════════════════════════════════╝ ■ CLEARED RECEIVERS REPORT ╔════════════════════════════════════════════════════════╗ ║ The Cleared Receivers Report is 1 of 4 Purchase ║ ║ Clearing Reports for DAYO AP. This reports lists ║ ║ all cleared receivers (PC=.T.), from the database ║ ║ REC.DBF for a selected date range... ║ ║ ║ ║ Start Date: 03/05/90 Ending Date: 04/04/90 ║ ║ ║ ║ Select Index -> KEY ║ ║ ║ ║ Send Output to Printer? (Y/N) ( No -> To File) ║ ║ ║ ║ Enter File Name: PCREC.TXT ║ ║ ║ ║ Enter Report Title: TJS LAB ║ ║ ║ ╚════════════════════════════════════════════════════════╝ DAYO AP, TJS LAB Page: 63 ■ CLEARED AP RECORDS REPORT ╔════════════════════════════════════════════════════════╗ ║ The Cleared AP Records Report is 1 of 4 Purchase ║ ║ Clearing Reports for DAYO AP. This reports lists ║ ║ all cleared AP Header Records (PC=.T.), from the ║ ║ database APH.DBF for a selected date range... ║ ║ ║ ║ Start Date: 03/05/90 Ending Date: 04/04/90 ║ ║ ║ ║ Select Index -> PO ║ ║ ║ ║ Send Output to Printer? (Y/N) ( No -> To File) ║ ║ ║ ║ Enter File Name: PCAPH.TXT ║ ║ ║ ║ Enter Report Title: TJS LAB ║ ║ ║ ╚════════════════════════════════════════════════════════╝ ■ AP AGEING REPORT ╔════════════════════════════════════════════════════════╗ ║ The AP Ageing Report summarizes your payables by ║ ║ Vendor, by 30 day periods. ║ ║ Uses only open (OPEN=.T) and uncleared AP Header ║ ║ Records (PC=.F.),... ║ ║ ║ ║ Send Output to Printer? (Y/N) ( No -> To File) ║ ║ ║ ║ Enter File Name: APAGEING.TXT ║ ║ ║ ║ Enter Number of Lines Per Page: 54 ║ ║ ║ ║ Enter Report Title: Your Company Name ║ ║ ║ ║ ┌┬┬┬┬┬┬┬┬┬┬┬┬┬┬┬┬┬┬┬┬┬┬┬┬┬┬┬┬┬┬┬┬┬┬┬┬┬┬┬┬┬┬┬┬┬┬┬┬┬┐ ║ ║ ├█████████████████████┼ ┼ ┼ ┼ ┼ ┼ ┼ ┼ ┼ ┼ ┼ ┼ ┼ ┼ ┤ ║ ║ └┴┴┴┴┴┴┴┴┴┴┴┴┴┴┴┴┴┴┴┴┴┴┴┴┼┴┴┴┴┴┴┴┴┴┴┴┴┴┴┴┴┴┴┴┴┴┴┴┴┘ ║ ║ 0% 25% 50% 75% Done ║ ║ Total: 1032669.16 ║ ╚════════════════════════════════════════════════════════╝ DAYO AP, TJS LAB Page: 64 ■ AP HEADER REPORT This is probably the 'Work Horse' Report for AP. Run this report as often as necessary to reconcile or to list your payables (AP Header records). Many options exist for this report, ie: All or specific vendor, multiple indexes, 3 formats/styles, and directing output to printer or file. ╔════════════════════════════════════════════════════════╗ ║ The AP Header Report contains a listing of all ║ ║ the open payables (OPEN=.T.). Data is derived ║ ║ from the database APH.DBF. ║ ║ Select Index and Date Range... ║ ║ ║ ║ Start Date: 08/03/91 Ending Date: 09/02/91 ║ ║ ║ ║ Select Option -> Report All Open ║ ║ Report Specific Vendor ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ╚════════════════════════════════════════════════════════╝ Select 1 of 5 indexes, ie: ╔════════════════════════════════════════════════════════╗ ║ The AP Header Report contains a listing of all ║ ║ the open payables (OPEN=.T.). Data is derived ║ ║ from the database APH.DBF. ║ ║ Select Index and Date Range... ║ ║ ║ ║ Start Date: 08/03/91 Ending Date: 09/02/91 ║ ║ ║ ║ Select Index -> Purchase Order ║ ║ Vendor Name ║ ║ Vendor Number ║ ║ Journal Number ║ ║ Work Order ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ╚════════════════════════════════════════════════════════╝ DAYO AP, TJS LAB Page: 65 Select 1 of 3 styles/formats, ie: ╔════════════════════════════════════════════════════════╗ ║ The AP Header Report contains a listing of all ║ ║ the open payables (OPEN=.T.). Data is derived ║ ║ from the database APH.DBF. ║ ║ Select Index and Date Range... ║ ║ ║ ║ Start Date: 08/03/91 Ending Date: 09/02/91 ║ ║ ║ ║ Select Index -> Purchase Order ║ ║ ║ ║ Select Format -> Style 1, 80 wide ║ ║ Style 2, 131 wide ║ ║ Style 3, 155 wide ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ╚════════════════════════════════════════════════════════╝ The other option is to enter a report heading (defaults to your company name), and a file name (if printing to a file), ie: ╔════════════════════════════════════════════════════════╗ ║ The AP Header Report contains a listing of all ║ ║ the open payables (OPEN=.T.). Data is derived ║ ║ from the database APH.DBF. ║ ║ Select Index and Date Range... ║ ║ ║ ║ Start Date: 08/03/91 Ending Date: 09/02/91 ║ ║ ║ ║ Select Index -> Purchase Order ║ ║ ║ ║ Select Format -> Style 1, 80 wide ║ ║ ║ ║ Send Output to Printer? (Y/N) ( No -> To File) ║ ║ ║ ║ Enter File Name: APH.TXT ║ ║ ║ ║ Enter Report Title: Your Company Name ║ ║ ║ ║ ║ ╚════════════════════════════════════════════════════════╝ DAYO AP, TJS LAB Page: 66 ■ ACCOUNTS PAYABLE DETAIL REPORT There are 5 indexes to select from: Select the Index -> PURCHASE ORDER (PO) ITEM (ITEM) VENDOR CODE (VENDOR) VENDOR ITEM (VENDITEM) JOURNAL # (JOURNAL) ╔════════════════════════════════════════════════════════╗ ║ The AP (Payables) Detail Report lists all Open ║ ║ and/or Closed APD.DBF records. Multiple Indexes. ║ ║ ║ ║ The name of the AP Detail Report Form is APD.FRM. ║ ║ ║ ║ Select the Index -> ITEM (ITEM) ║ ║ VENDOR CODE (VENDOR) ║ ║ VENDOR ITEM (VENDITEM) ║ ║ JOURNAL # (JOURNAL) ║ ║ Enter Heading: YOUR COMPANY, INC ║ ║ ║ ║ Send Output to Printer? (Y/N) ( No -> To File) ║ ║ ║ ║ Enter File Name: APDETAIL.TXT ║ ║ ║ ║ ║ ║ ║ ║ Start Date: 06/24/86 Ending Date: 06/23/91 ║ ╚════════════════════════════════════════════════════════╝ ■ REPRINT CHECKS ╔═════════════════════════════════════════════════╗ ║ REPRINT CHECKS ║ ║ ║ ║ This routine allows you to reprint checks found║ ║ in the database CHECKS.DBF. Detailed voucher ║ ║ information will not be printed. ║ ║ ║ ║ Enter Beginning Check Number: 324 ║ ║ ║ ║ Enter Ending Check Number: 324 ║ ║ ║ ║ Checkno Name Amount ║ ║ 324 George Moonilal 343.32║ ║ ║ ║ ║ ║ ║ ╟────────────────┬────────────────┬───────────────╢ ╟████████████████████████─────────┼───────────────╢ ╚════════════════╧════════════════╧═══════════════╝ DAYO AP, TJS LAB Page: 67 ■ CONFIGURATION STATUS REPORT ╔═══════════════════════════════════════════════════════╗ ║The Configuration Status Settings Report lists all of ║ ║configuration settings (found in file DAYOAP.CFG). ║ ║This is Not a Report Form. ║ ║ ║ ║Send Output to Printer? (Y/N) ( No -> To File) ║ ║ ║ ║Enter File Name: CONFIG.TXT ║ ╚═══════════════════════════════════════════════════════╝ ■ EXAMPLE OF CONFIGURATION STATUS REPORT ++++++++++++++++++++++++++++++++++++++++++++++ + DAYO ACCOUNTS PAYABLE CONFIGURATION REPORT + ++++++++++++++++++++++++++++++++++++++++++++++ 04/05/90 21:57:55 Company Name: YOUR COMPANY NAME HERE Address Line 1: Attn: Accounts Payable Address Line 2: P.O. Box 5555 City, State Zip: ANYCITY, ST 55555 Telephone: 800-555-5555 Inventory Database Location: \DAYOINV\ POS Database Location: \DAYOPOS\ Customer Database Location: \DAYOAR\ GL Database Location: \DAYOGL\ Federal (Tax) Id Number: Default Form 1099 TYPE Code: 99 Default Tax Rate: 0.060 Report Printer Type: STANDARD PRINTER Report Printer Port: LPT1 Hand Checks Port: LPT1 Batch Checks Port: LPT1 Recurring Checks Port: LPT1 Partial Payment POs: Yes Partial Pay Freight: Partial Payment Automatic GL Posting: No Visual Indexing: Yes Automatic Reindexing: Yes Color: Yes High Intensity: No DAYO AP, TJS LAB Page: 68 ■ VIEW REPORTS ON SCREEN This routine was provided to aid the 'fight to stop the cutting down of trees in the world' by offering you the option to view your reports on your screen. The only limitation is on the size of the report. No reports can be viewed if they are over 32,000 bytes. (Just kidding about those trees...) Due to compiler problems (handling of memory), this routine tends to 'hang' your computer. It is not recommended you use this option if your machine is performing multitasking programs. At the first prompt, type and enter the name of the report you wish to view. ╔═════════════════════════▌ View Reports Onscreen ▐══════════════════════════╗ ║██ ██░ ████░ ████░ ██░ ██░ ██▄██░ █████░ ██▄██░ ▄███▄ ██▄██░ ██████║ ║ ██ ██░ ██░ ██░ ██░ █░ ██░ ██░██░ ██░ ██░██░ ██░██░ ██░██░ ██░ ║ ║ ██ ██░ ██░ ███░ ██░███░██░ █████░ ████░ █████░ ██░██░ █████░ ██░ ║ ║ ████░ ██░ ██░ ███░███░ ██▀█░ ██░ ██░ ██░██░ ██▀█░ ██░ ║ ║ ██░ ████░ ████░ ██░██░ ██░██░ █████░ ██░ ▀███▀ ██░██░ ██░ ║ ║ ║ ║ Use this option to view (and optionally print) any report written to disk. ║ ║ Press Enter/Return on an empty prompt to display all files with the ║ ║ extension of '.TXT'. ║ ║ No limit on file size, but a large file/report takes longer to 'load'... ║ ║ ║ ║ Enter Report File Name to View On Screen: ║ ╚════════════════════════════════════════════════════════════════════════════╝ If the file does not exist, or you press enter on an empty prompt, a window will appear showing all reports in the current directory. It is assumed that all reports will have the extension of '.TXT', which is the DAYO standard. All reports are displayed in the window, even if they are too large... ╔═══════════════════════════════════════╗ ║ File Name Size Date Used ║ ╟──────────────┬────────────┬───────────╢ ║DAYOERR.TXT │ 1090 │ 06/15/90 ║ ║BALANCE.TXT │ 3555 │ 06/15/90 ║ ║GL900615.TXT │ 79 │ 06/15/90 ║ ║CONFIG.TXT │ 1209 │ 06/15/90 ║ ║BUDGETSC.TXT │ 4129 │ 06/15/90 ║ ║CLASSRPT.TXT │ 1058 │ 06/02/90 ║ ║COA.TXT │ 1158 │ 06/02/90 ║ ┌────────────────────────┐ ║GL900602.TXT │ 1759 │ 06/02/90 ║ │ Highlight the Report │ ║PERIODS.TXT │ 968 │ 06/15/90 ║ │ using the Up or Down │ ║TRANS3.TXT │ 659 │ 06/02/90 ║ │ arrow keys, then press │ ║TRIAL.TXT │ 6712 │ 06/15/90 ║ │ Enter/Return. │ ║INC_EXP.TXT │ 3291 │ 06/15/90 ║ └────────────────────────┘ ║TRANS1.TXT │ 659 │ 06/15/90 ║ ║ASSETS.TXT │ 1300 │ 06/15/90 ║ ║EQUITY.TXT │ 714 │ 06/15/90 ║ ╚══════════════╧════════════╧═══════════╝ DAYO AP, TJS LAB Page: 69 ■ REPORT VIEWING SCREEN The report viewing screen uses the complete screen. The top line displays the report name. The bottom lines show you the function keys, all 2 of them. Also displayed at the bottom of the screen is the current row/column of the cursor position. DAYOAP View Reports │ File Name: COA.TXT Page No. 1 07/27/90 INVENTORY ITEM LISTING Vendor or Item Mfg Item Description ------------ ------------ ------------------------------ 2" GUTTER 2" GUTTER SYSTEM _____________ 2ALM518 2" ALMOND COIL _____________ 2ALM519 2" ALMOND COIL _____________ 2ALM527 2" ALMOND COIL _____________ 2ALM533 2" ALMOND COIL _____________ 2ANT123 2" ANT IVORY COIL _____________ Esc (Exit) F1 (Help) DAYO AP, TJS LAB Page: 70 ■ PRINTER DRIVER (SETUP) This routine was added to preclude you from having to get out of your seat to change (mess with) the printer to get it to print correctly. The most important printer selections (ie: font size, lines per inch, orientation, ...) are made easy to evoke. ╔════════════════════════════════════════════════════════════════════════════╗ ║ █▄██░█▄██░███░█░ █░█████░███░█▄██░ █▄██▄ █▄██░███░█░ █░███░█▄██░ ║ ║ █░ █░█░ █░ █░ ██░ █░ █░ █░ █░ █░ █░ █░█░ █░ █░ █░ █░█░ █░ █░ ║ ║ █▀██░████░ █░ ███░█░ █░ ██░ ████░ █░ █░████░ █░ █▄ ▄█░██ ████░ ║ ║ █░ █░█░ █░ █░███░ █░ █░ █░█░ █░ █░█░█░ █░ █░█░ █░ █░█░ ║ ║ █░ █░▀█░ █░ █░ ██░ █░ █░ █░▀█░ █░ █░█░▀█░ █░ █▄█░ █░ █░▀█░ ║ ║ █░ █░ █░███░█░ █░ █░ ███░█░ █░ █▀██▀ █░ █░███░ █░ ███░█░ █░ ║ ║ ║ ║ Select Option -> Eject ║ ║ Line feed ║ ║ Normal Size ║ ║ Use this routine to set your Small/Condensed ║ ║ printer up with one or more Bold On ║ ║ of the setup strings and Bold Off ║ ║ commands listed to the right. 6 Lines per Inch ║ ║ 8 Lines per Inch ║ ║ Select the 'Change Printer Print Landscape (Laser Only) ║ ║ Default' option to change Print Portrait (Laser Only) ║ ║ printer types. Reset Printer ║ ║ Current printer is set to: Print Special String 1 ║ ║ Okidata Print Special String 2 ║ ║ Print Special String 3 ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit) ■ PRINTER DRIVER OPTIONS There are 18 printer driver options to select from. The last option is to set the default printer, and the next to last is a 'SHELL' function that runs a DOS command or program. The remainder are strings/codes that are sent to the printer. Eject Print Portrait (Laser Only) Line feed Reset Printer Normal Size Print Special String 1 Small/Condensed Print Special String 2 Bold On Print Special String 3 Bold Off Print Special String 4 6 Lines per Inch Print Special String 5 8 Lines per Inch Run DOS Command/Program Print Landscape (Laser Only) Change Default Printer DAYO AP, TJS LAB Page: 71 ■ CHANGE DEFAULT PRINTER The last option is to change/set the default printer. This printer driver routine comes with 4 default printer types, Epson, HP Laser, Star, and Okidata. You can add (Ctrl N) as many as you want. ╔════════════════════════════════════════════════════════════════════════════╗ ║ █▄██░█▄██░███░█░ █░█████░███░█▄██░ █▄██▄ █▄██░███░█░ █░███░█▄██░ ║ ║ █░ █░█░ █░ █░ ██░ █░ █░ █░ █░ █░ █░ █░█░ █░ █░ █░ █░█░ █░ █░ ║ ║ █▀██░████░ █░ ███░█░ █░ ██░ ████░ █░ █░████░ █░ █▄ ▄█░██ ████░ ║ ║ █░ █░█░ █░ █░███░ █░ █░ █░█░ █░ █░█░█░ █░ █░█░ █░ █░█░ ║ ║ █░ █░▀█░ █░ █░ ██░ █░ █░ █░▀█░ █░ █░█░▀█░ █░ █▄█░ █░ █░▀█░ ║ ║ █░ █░ █░███░█░ █░ █░ ███░█░ █░ █▀██▀ █░ █░███░ █░ ███░█░ █░ ║ ╟────────────────────────────────────────────────────────────────────────────╢ ║ Current Default Printer is set to: Okidata ║ ╟────────────────────────────────────────────────────────────────────────────╢ ║ NAME LINEFEED ║ ║─────────────────────────────────────╥──────────────────────────────────────║ ║ Epson & Compatibles ║ CHR(10) ║ ║ HP Laser & Compatibles ║ CHR(10) ║ ║ Star Micro Gemini ║ CHR(10) ║ ║ Okidata ║ CHR(10) ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit) Enter/Return (Make Default) F2 (Edit) Ctrl N (Add) 1/4 DAYO AP, TJS LAB Page: 72 ■ FULL SCREEN EDIT - F2 When entering the printer codes, the string must be in the valid format or it will not be printed later when requested... ┌───────────[ EDIT PRINTER DRIVER SETUP CODES - FULL SCREEN EDIT ]───────────┐ │ NAME: Epson & Compatibles │ │ LINEFEED: CHR(10) │ │ NORMAL: CHR(27)+CHR(18) │ │ SMALL: CHR(27)+CHR(15) │ │ BOLDON: CHR(27)+CHR(69) │ │ BOLDOFF: CHR(27)+CHR(70) │ │ _6LPI: CHR(27)+CHR(50) │ │ _8LPI: CHR(27)+CHR(48) │ │ PORTRAIT: │ │ LANDSCAPE: │ │ RESET: CHR(27)+CHR(64) │ │ SPEC_STR1: │ │ SPEC_STR2: │ │ SPEC_STR3: │ │ SPEC_STR4: │ │ SPEC_STR5: │ │ RUN_CMD: │ │ │ │ │ └────────────────────────────────────────────────────────────────────────────┘ Press Esc to Abort, PgUp/PgDn to Save and Exit ■ PRINTER DRIVER DATABASE FIELD DEFINITIONS NAME - Name of printer. Type in anything you wish here LINEFEED - Code to advance printer one line NORMAL - Normal font/character size SMALL - Small font/character size BOLDON - Bold/Emphasized BOLDOFF - Bold/Emphasized off _6LPI - Code to set printer to print 6 lines per inch _8LPI - Code to set printer to print 8 lines per inch PORTRAIT - Code to set laser printer to print upright (normal) LANDSCAPE - Code to set laser printer to print sideways RESET - Reset printer code SPEC_STR1 - Any special printer string, ie: print double, skip perforation, SPEC_STR2 - print very tiny, ... SPEC_STR3 - " SPEC_STR4 - " SPEC_STR5 - " RUN_CMD - DOS command or program, ie: CAPTURE p0 nff,SPOOL ON, ... DAYO AP, TJS LAB Page: 73 ■ CONFIGURATION The configurations settings (19) are all accessed from within the CONFIGURATION menu (option 6 from the main menu). ╔════════════════════════╗ ║ CONFIGURATION ║ ╟────────────────────────╢ ║ Company Name ║ ║ Company Address ║ ║ Company Telephone ║ ║ Inventory Location ║ ║ POS Location ║ ║ Customer (AR) Location ║ ║ Federal Id Number ║ ║ Default 1099 TYPE Code ║ ║ Default Tax Rate ║ ║ Report Printer Type ║ ║ Report Printer Port ║ ║ Hand Checks Port ║ ║ Batch Checks Port ║ ║ Recurring Checks Port ║ ║ Partial Payment POs ║ ║ Partial Pay Freight ║ ║ Visual Indexing ║ ║ Auto Daily Indexing ║ ║ Color ║ ╟────────────────────────╢ ║ Select Option ║ ╚════════════════════════╝ ■ CONFIGURATION LISTING Company Name Report Printer Port Company Address Hand Checks Port Company Telephone Batch Checks Port Inventory Location Recurring Checks Port POS Location Partial Payment POs Customer (AR) Location Partial Pay Freight Federal Id Number Visual Indexing Default 1099 TYPE Code Auto Daily Indexing Default Tax Rate Color Report Printer Type Automatic GL Posting GL Location DAYO AP, TJS LAB Page: 74 ■ COMPANY NAME, ADDRESS & TELEPHONE Each field for this option is limited to 30 characters, 14 for the telephone... ┌──────────────────────────────[ COMPANY NAME ]──────────────────────────────┐ │ Enter Your Company Name: YOUR COMPANY NAME HERE │ └────────────────────────────────────────────────────────────────────────────┘ ┌────────────────────────────[ COMPANY ADDRESS ]─────────────────────────────┐ │ Address Line 1: Attn: Accounting │ │ Address Line 2: P.O. BOX 5555 │ │ City, State ZIP: ANYCITY, ST 55555-5555 │ └────────────────────────────────────────────────────────────────────────────┘ ┌───────────────────────────[ COMPANY TELEPHONE ]────────────────────────────┐ │ Enter Your Company Telephone: 800-555-5555 │ └────────────────────────────────────────────────────────────────────────────┘ ■ INVENTORY LOCATION/DIRECTORY ┌───────────────────────[ INVENTORY LOCATION/DIRECTORY ]─────────────────────┐ │ The location of the DAYO Inventory (INV.DBF) does not have to be in the │ │ same drive/directory as DAYO AP. If you have installed DAYO Inventory │ │ into a different directory, you need to tell DAYO AP where to find │ │ the inventory database (INV.DBF). Default is nil (current directory). │ │ Be sure to include the rightmost slash, ie: \DAYOINV\ │ │ The drive designation is optional (if same as DAYO AP). │ │ │ │ Enter Location: \DAYOINV\ │ └────────────────────────────────────────────────────────────────────────────┘ ■ POINT OF SALE (POS) DATABASES LOCATION/DIRECTORY ┌─────────────[ POINT OF SALE (POS) DATABASES LOCATION/DIRECTORY ]───────────┐ │ The location of the DAYO POS files (ie INVOICE.DBF) does not have to be │ │ in the same drive/directory as DAYO AP. If you have installed the │ │ DAYO POS Databases, into a different directory, you need to tell DAYO │ │ AP where to find it. Default is nil (current directory). │ │ Be sure to include the rightmost slash, ie: \DAYOPOS\ │ │ The drive designation is optional (if same as DAYO AP). │ │ │ │ Enter Location: \DAYOPOS\ │ └────────────────────────────────────────────────────────────────────────────┘ DAYO AP, TJS LAB Page: 75 ■ CUSTOMER (AR) DATABASE LOCATION/DIRECTORY ┌────────────────[ CUSTOMER (AR) DATABASE LOCATION/DIRECTORY ]───────────────┐ │ The location of the DAYO Customer and other AR databases does not have to │ │ be in the same drive/directory as DAYO AP. If you have installed the │ │ DAYO Customer/AR Databases, into a different directory, you need to tell │ │ DAYO End of Period where to find it. Default is nil (current directory). │ │ Be sure to include the rightmost slash, ie: \DAYOAR\ │ │ The drive designation is optional (if same as DAYO AP). │ │ │ │ Enter Location: \DAYOAR\ │ └────────────────────────────────────────────────────────────────────────────┘ ■ GENERAL LEDGER (GL) DATABASE LOCATION/DIRECTORY ┌────────────[ GENERAL LEDGER (GL) DATABASE LOCATION/DIRECTORY ]─────────────┐ │ The location of DAYO General Ledger Databases does not have to be │ │ in the same drive/directory as this module. If you have installed DAYO GL │ │ into a different directory, you need to tell this module where to find │ │ the GL databases. Default is nil (current directory). │ │ Be sure to include the rightmost slash, ie: \DAYOGL\ │ │ The drive designation is optional (if same as this module). │ │ │ │ Enter Location: \DAYOGL\ │ └────────────────────────────────────────────────────────────────────────────┘ ■ FEDERAL (TAX) IDENTIFICATION NUMBER (FIN) ┌────────────────[ FEDERAL (TAX) IDENTIFICATION NUMBER (FIN) ]───────────────┐ │ This entry is your Federal Identification Number for tax reporting. │ │ It is included on various reports, ie: Form 1099s. │ │ │ │ Enter Your FIN: 74567456 4565oo │ └────────────────────────────────────────────────────────────────────────────┘ ■ FORM 1099 DEFAULT TAX CODE ┌────────────────────────[ FORM 1099 DEFAULT TAX CODE ]──────────────────────┐ │ This entry is use when determining which Accounts Payable Records should │ │ be used in the calculation of Federal Form 1099 Misc. Default is '99 '. │ │ The field containing the type code is TYPE, in the database APH.DBF. │ │ │ │ Enter Your Default 1099 Tax Code: 99 │ └────────────────────────────────────────────────────────────────────────────┘ DAYO AP, TJS LAB Page: 76 ■ DEFAULT TAX RATE ┌────────────────────────────[ DEFAULT TAX RATE ]────────────────────────────┐ │ │ │ This Tax Rate will be the default tax rate at prompts for same. │ │ │ │ Enter Default Tax Rate: 0.060 │ │ │ └────────────────────────────────────────────────────────────────────────────┘ ■ REPORT PRINTER TYPE ┌───────────────────────────[ REPORT PRINTER TYPE ]──────────────────────────┐ │ Routine reports are printed according to this selection. │ │ The STANDARD printer type is a Epson/IBM Proprinter compatible printer. │ │ The LASER printer type is a Hewlett Packard Laser compatible printer. │ │ Special Laser codes are sent to the LASER option. │ │ │ │ Enter Your Report Printer Type -> STANDARD │ │ LASER │ └────────────────────────────────────────────────────────────────────────────┘ ■ REPORT PRINTER PORT ┌───────────────────────────[ REPORT PRINTER PORT ]──────────────────────────┐ │ Enter Your Report Printer Port (1,2,3): 1 │ └────────────────────────────────────────────────────────────────────────────┘ ■ HAND CHECKS PRINTER PORT ┌────────────────────────[ HAND CHECKS PRINTER PORT ]────────────────────────┐ │ Enter Your Hand Checks Printer Port (1,2,3): 1 │ └────────────────────────────────────────────────────────────────────────────┘ ■ BATCH CHECKS PRINTER PORT ┌───────────────────────[ BATCH CHECKS PRINTER PORT ]────────────────────────┐ │ Enter Your Batch Checks Printer Port (1,2,3): 1 │ └────────────────────────────────────────────────────────────────────────────┘ DAYO AP, TJS LAB Page: 77 ■ RECURRING CHECKS PRINTER PORT ┌─────────────────────[ RECURRING CHECKS PRINTER PORT ]──────────────────────┐ │ Enter Your Recurring Checks Printer Port (1,2,3): 1 │ └────────────────────────────────────────────────────────────────────────────┘ ■ AP POSTING - PARTIAL PAYMENT OF PURCHASE ORDERS ┌────────────[ AP POSTING - PARTIAL PAYMENT OF PURCHASE ORDERS ]─────────────┐ │ Select Y to this prompt if you wish your Purchase Orders to be paid │ │ partially (as they are received), otherwise POs are paid upon full │ │ receipt. │ │ Do you wish to Partial Pay your Purchase Order Receipts? (Y/N) │ └────────────────────────────────────────────────────────────────────────────┘ ■ AP POSTING - PARTIAL PAYMENT OF PO FREIGHT & ADJUSTMENTS ┌────────[ AP POSTING - PARTIAL PAYMENT OF PO FREIGHT & ADJUSTMENTS ]────────┐ │ Payment of Freight and Adjustments (FREIGHT & ADJUST), upon receipt of │ │ product, can be paid to the Vendor based on one of the following options.│ │ │ │ Select Option: │ │ 1 - Partial Payment of PO FREIGHT & ADJUST │ │ 2 - Complete Payment of PO FREIGHT & ADJUST on First Receipt │ │ 3 - Complete Payment of PO FREIGHT & ADJUST on Final Receipt │ └────────────────────────────────────────────────────────────────────────────┘ DAYO AP, TJS LAB Page: 78 ■ AUTOMATIC GL POSTING This Configuration routine was added to allow you to post your transactions (ie: Payables, Checks, and Deposits), automatically into General Ledger (GL). If this option is set to 'Y' (Yes), each time you adjust or edit key accounting fields (ie: AMOUNT, SUBTOTAL, FREIGHT, TAXES, ADJUST, COST, QTY...), a GL transaction records will be created. This routine includes an option to browse, edit, add, and/or delete records in the General Ledger Class Code Table/Database (GLCLASS.DBF). ╔══════════════════════════[ AUTOMATIC GL POSTING ]══════════════════════════╗ ║ If you are using General Ledger (GL), you can automatically update ║ ║ or create GL transactions every time you make an accounting adjustment. ║ ║ ║ ║ Do you want Automatic GL Posting? (Y/N) ║ ║ ║ ║ Default CLASS Code: AP Name: AP TOTAL ║ ║ Debit Account: 10000-000000 Credit Account: 20000-000000 ║ ║ Database: APH.DBF Field: AMOUNT ║ ╟──────────────[ SELECT DEFAULT ACCOUNTS PAYABLE CLASS CODE ]────────────────╢ ║ CLASS NAME DEBIT CREDIT ║ ║──────────╥────────────────────────────────╥──────────────╥─────────────────║ ║ AP ║ AP TOTAL AMOUNT ║ 10000-000000 ║ 40000-000000 ║ ║ AP ║ AP TOTAL SUBTOTAL ║ 10000-000000 ║ 40000-000000 ║ ║ AP ║ AP TOTAL TAXES ║ 10000-000000 ║ 40000-000000 ║ ║ AP ║ AP TOTAL FREIGHT ║ 10000-000000 ║ 40000-000000 ║ ║ AP ║ AP TOTAL ADJUST ║ 10000-000000 ║ 40000-000000 ║ ║ DEP ║ DEPOSIT INTO CHECKING ║ 91000-000000 ║ 20000-000000 ║ ║ INV ║ RECEIPTS INTO THE INVENTORY ║ 91000-000000 ║ 11000-000000 ║ ║ AP ║ HAND CHECK ║ 10000-000000 ║ 20000-000000 ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit) F1 (Help) F2 (Edit) Ctrl N (Add) Ctrl U (Delete) Find: F5 (CLASS) F6 (DEBIT) F7 (CREDIT) F8 (NAME) F9 (DATABASE) 20/20 DAYO AP, TJS LAB Page: 79 ■ EDIT CLASS CODE RECORD Press 'F2' to edit a Class Code record. Note, valid entries are crucial to making this posting process work correctly... ╔════════════════════════[ EDIT AP CLASS CODE RECORD ]═══════════════════════╗ ║ CLASS Code: AP ║ ║ Name: AP FREIGHT ║ ║ Debit Account: 11000-000000 ║ ║ Credit Account: 10000-000000 ║ ║ Database (.DBF): APH.DBF ║ ║ Field: FREIGHT ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit) F1 (Help) PgUp/PgDn (Save & Exit) ■ ADD NEW CLASS CODE RECORD Press 'Ctrl N' to add a new CLASS code record. ╔══════════════════════[ ADD NEW AP CLASS CODE RECORD ]══════════════════════╗ ║ CLASS Code: ║ ║ Name: ║ ║ Debit Account: 00000-000000 ║ ║ Credit Account: 00000-000000 ║ ║ Database (.DBF): APH.DBF ║ ║ Field: ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit) F1 (Help) PgUp/PgDn (Save & Exit) DAYO AP, TJS LAB Page: 80 ■ FIND CLASS CODE Use the F5 through F9 keys to locate a desired CLASS code record Press F5 to locate a CLASS code record based on the CLASS field, ie: ┌─────────────────────────────────────────────────────────────┐ │ Enter CLASS+DATABASE: │ └───────────────────────────────────────────────────TJS LAB───┘ Press F6 to locate a CLASS code record based on the DEBIT field, ie: ┌─────────────────────────────────────────────────────────────┐ │ Enter DEBIT: 30000-200000 │ └───────────────────────────────────────────────────TJS LAB───┘ Press F7 to locate a CLASS code record based on the CREDIT field, ie: ┌─────────────────────────────────────────────────────────────┐ │ Enter CREDIT: 10000-200000 │ └───────────────────────────────────────────────────TJS LAB───┘ Press F8 to locate a CLASS code record based on the NAME field, ie: ┌─────────────────────────────────────────────────────────────┐ │ Enter NAME: │ └───────────────────────────────────────────────────TJS LAB───┘ Press F9 to locate a CLASS code record based on the DATABASE field, ie: ┌─────────────────────────────────────────────────────────────┐ │ Enter DATABASE: │ └───────────────────────────────────────────────────TJS LAB───┘ ■ VISUAL INDEXING ┌────────────────────────────[ VISUAL INDEXING ]─────────────────────────────┐ │ If you desire to see a progress graph each time your indexes are │ │ created, then select Y (YES). Note, the process can slow the indexing │ │ routine down; especially with larger databases. │ │ │ │ Do you wish to have Visual Indexing? (Y/N) │ └────────────────────────────────────────────────────────────────────────────┘ DAYO AP, TJS LAB Page: 81 ■ AUTOMATIC DAILY INDEXING ┌─────────────────────────[ AUTOMATIC DAILY INDEXING ]───────────────────────┐ │ If this option is set to Y (YES), then all DAYO Indexes accessed by │ │ DAYO AP will be recreated once daily. This will occur when the first │ │ DAYO AP program is run. The default is to recreate all the indexes. │ │ │ │ Recreate all DAYO AP Indexes? (Y/N) │ └────────────────────────────────────────────────────────────────────────────┘ ■ COLOR MONITOR To activate a color change, you must completely exit DAYO AP, and reenter. ┌──────────────────────────────[ COLOR MONITOR ]─────────────────────────────┐ │ If you have a color monitor and wish to display colors, then select Y, │ │ (YES), else select N (NO) for monochrome and others. │ │ The default is color, low intensity │ │ │ │ Do you have a color monitor? (Y/N) │ └────────────────────────────────────────────────────────────────────────────┘ ■ COLOR INTENSITY ┌─────────────────────────────[ COLOR INTENSITY ]────────────────────────────┐ │ Intensity is only applicable with color set to Y. │ │ It will make your colors brighter... │ │ │ │ Set Color Intensity On? (Y/N) │ └────────────────────────────────────────────────────────────────────────────┘ DAYO AP, TJS LAB Page: 82 ■ MISCELLANEOUS ROUTINES - The MISC routines is a collection of 17 very useful Database Management Routines. These routines provide you with the 'ability to do whatever was left out of the rest of the program...'. These routines were modeled after dBase (tm) III+/IV functions. Familiarity with dBase will help with the understanding and execution of these routines. USE WITH CAUTION! YOU CAN ENHANCE AND CUSTOMIZE YOUR PROGRAM WITH THESE ROUTINES YOU CAN ALSO MESS THINGS UP PERMANENTLY! ■ MISC ROUTINES MENU: DAYO AP Version 4.0 TJS LAB ┌───[February 1992]──┐ ╔════════════════════╗─╖ │S M T W T F S │ ║ MISC ROUTINES ║ ║ █▄██▄ ▄█▄ █░ █░ ▄███▄ ├────────────────────┤ ╟────────────────────╢─╢ █░ █░ █░█░ █░ █░ █░ █░ │ 1 2 3 4 5 6 7│ ║ APPEND FROM ║ ║ █░ █░ █░█░ ▀█░██░ █░ █░ │ 8 9 10 11 12 13 14│ ║ BROWSE DATABASES ║─╢ █░ █░ █▀▀▀█░ ▀█▀ █░ █░ │15 16 17 18 19 20 21│ ║ COPY (.DBF) TO ║ ║ █░ █░ █░ █░ █░ █░ █░ │22 23 24 25 26 27 28│ ║ CREATE DATABASE ║─╢ █▀██▀ █░ █░ █░ ▀███▀ │29 30 │ ║ DELETE RECORDS ║ ║ │ │ ║ ERASE FILE ║─╢ └────────────────────┘ ║ EXIT TO DOS ║ ║ ║ INDEX A DATABASE ║─╢ ████░ █░ █░ █▄██▄ ▄███▄ ████░ ║ LIST FIELDS ║ ║ █░ ██░ █░ █░ █░ █░ █░ █░ ║ PACK DATABASE ║─╢ ███░ ███░█░ █░ █░ █░ █░ ████░ ║ MODIFY DATABASE ║ ║ █░ █▀███░ █░ █░ █░ █░ █░ ║ RECALL RECORDS ║─╢ █░ █░▀██░ █░ █░ █░ █░ █░ ║ RETURN TO MENU ║ ║ ████░ █░ ▀█░ █▀██▀ ▀███▀ █░ ║ RUN (DOS COMMAND) ║═╝ ║ SIMPLE EDITOR ║04/01/90 █▄██▄ ████░ █▄███░ ███░ ▄███▄ █▄██▄ ║ SORT DATABASE ║12:06:53 █░ █░ █░ █░ █░ █░ █░ █░ █░ █░ ║ TYPE (PRINT) FILE ║1 █░ █░ ███░ █▄▄▄█░ █░ █░ █░ █░ █░ ║ ZAP DATABASE ║3 █▀██▀ █░ █▀█▄ █░ █░ █░ █░ █░ ╟────────────────────╢3.00 █░ █░ █░ ▀█░ █░ █░ █░ █░ █░ ║ Select Option ║TLJ █░ ████░ █░ █░ ███░ ▀███▀ █▀██▀ ╚════════════════════╝ DAYO AP, TJS LAB Page: 83 ■ APPEND FROM - Used to copy records from one database into another database, or to create records from ASCII files (SDF or DELIMITED). - The Initial Screen will prompt you to enter the file name of the database you are to append/copy the data into. At this point, you can either type in the name of the target database, or ... ┌──────────────────────────────[ APPEND FROM ]───────────────────────────────┐ │ Enter Database Name To Append Data Into: │ │ Enter Nothing For Listing Of Current Directory... │ └────────────────────────────────────────────────────────────────────────────┘ - If it exists in the current directory, press enter on an empty prompt to display all databases to select from. ┌──────────────────────────────[ APPEND FROM ]──────────────────────────────┐ │ │ │ Enter Database Name To Append Data Into: │ │ Enter┌────────[ PICK A DATABASE ]───────────┐y... │ │ │ FILE NAME SIZE DATE USED│ │ │ ├──────────────┬────────────┬──────────┤ │ │ │INVENT.DBF │ 375 │ 09/16/89 │ │ │ │AR.DBF │ 7219 │ 09/16/89 │ │ │ │HISTORY.DBF │ 103 │ 09/16/89 │ │ │ │PERSONS.DBF │ 24271 │ 09/16/89 │ │ │ │CUSTOMER.DBF │ 289 │ 09/16/89 │ │ │ └──────────────┴────────────┴──────────┘ │ │ ┌───────────────────────┐│ │ │ Highlight a database ││ │ │ using the ││ │ │ arrow keys, then press││ │ │ Enter/Return. ││ │ └───────────────────────┘│ │ │ └───────────────────────────────────────────────────────────────────────────┘ - The next prompt will be to select the type of Append: ┌──────────────────────────────[ APPEND FROM ]─────────────────────────────┐ │ │ │ Enter Database Name To Append Data Into: │ │ Enter Nothing For Listing Of Current Directory... │ │ │ │ Append Data Into INVENT.DBF │ │ │ │ Type of Append: Standard SDF DELIMITED │ │ │ └──────────────────────────────────────────────────────────────────────────┘ DAYO AP, TJS LAB Page: 84 - If you are appending from another database (.DBF) then select 'Standard'. - Select the SDF option if you are appending from a 'flat' ASCII file. - Select the DELIMITED option if you are appending from a delimited ASCII file. Delimited files contain records in which the fields are separated by commas, and its character fields contained in double quotes... - If you select a Standard Append, you will then be prompted to enter the name of the database you wish to get the data from. If you selected the SDF or DELIMITED options, then enter the file name containing the data to be appended into your target database. ┌──────────────────────────────[ APPEND FROM ]─────────────────────────────┐ │ │ │ Enter Database Name To Append Data Into: │ │ Enter Nothing For Listing Of Current Directory... │ │ │ │ Append Data Into PERSONS.DBF │ │ │ │ Type of Append: Standard SDF DELIMITED │ │ │ │ Enter Database Name To Append Data FROM: PERSON1.TXT │ │ │ │ │ └──────────────────────────────────────────────────────────────────────────┘ - The number of records appended into the target database will be displayed upon completion of the task... ┌──────────────────────────────[ APPEND FROM ]───────────────────────────────┐ │ │ │ Enter Database Name To Append Data Into: │ │ Enter Nothing For Listing Of Current Directory... │ │ │ │ Append Data Into INVENT.DBF From INVENTY.DBF │ │ │ │ Type of Append: Standard SDF DELIMITED │ │ │ │ Enter Database Name To Append Data FROM: INVENT.DBF │ │ │ │ │ │ │ │ There Were 1 Records Appended Into INVENT.DBF │ │ │ │ │ │ │ │ Press Any Key To Continue... │ │ │ └────────────────────────────────────────────────────────────────────────────┘ DAYO AP, TJS LAB Page: 85 ■ BROWSE DATABASES - Used to edit/view records in a database. Enter the database name you wish to edit/browse, or if it exists in the current directory, press enter on an empty prompt to bring up a window box to select from. ┌───────────────────────────────────────────────────────────────┐ │ Enter Database Name: INVENT.DBF │ │ │ └───────────────────────────────────────────────────────────────┘ - If there exists an index (.NDX or .NTX), with the same name as the database, it will be utilized... The DAYO Inventory indexes are the exception. They are automatically set/used. - An example of a browse screen: TJS LAB, PO BOX 585366 ┌────────────────────────────────[ BROWSE SDF ]──────────────────────────────┐ │ MFG_PART DESC PRICE LIST │ │──────────────────╥────────────────────────────────╥────────────╥───────────│ │ 19730 ║ DAYO CONFIGURATION SETTINGS ║ 896.16 ║ 1792.32 │ │ 23429 ║ DAYO CUSTOMER ║ 1064.19 ║ 2128.38 │ │ 14797 ║ DAYO END OF PERIOD/DAY ║ 672.12 ║ 1344.24 │ │ 38227 ║ DAYO FINANCE,PERSONNEL,PAYROLL ║ 1736.31 ║ 3472.62 │ │ 11098 ║ DAYO INVENTORY ║ 504.09 ║ 1008.18 │ │ 17264 ║ DAYO MISC ROUTINES ║ 784.14 ║ 1568.28 │ │ 30828 ║ DAYO PICK, INVOICING ║ 1400.25 ║ 2800.50 │ │ 35760 ║ DAYO PURCHASE ORDERS ║ 1624.29 ║ 3248.58 │ │ 25896 ║ DAYO QUOTES ║ 1176.21 ║ 2352.42 │ │ 62889 ║ DAYO ROPA ║ 2856.51 ║ 5713.02 │ │ 64122 ║ DAYO ROPA/ROPC SOURCE ║ 2912.52 ║ 5825.04 │ │ 28362 ║ DAYO SALES ORDERS, P.O.S. ║ 1288.23 ║ 2576.46 │ │ 33294 ║ DAYO VENDORS ║ 1512.27 ║ 3024.54 │ │ 66588 ║ DBASE TRAINING (PER HOUR) ║ 3024.54 ║ 6049.08 │ │ 16031 ║ EOP SOURCE ║ 728.13 ║ 1456.26 │ │ 49325 ║ EXPENSES SOURCE ║ 2240.40 ║ 4480.80 │ │ 39460 ║ FINANCE SOURCE ║ 1792.32 ║ 3584.64 │ ├──────────────────╨────────────────────────────────╨────────────╨───────────┤ │ Esc(EXIT) Ctrl N(ADD) Ctrl U(DELETE) F5(Find) │ └────────────────────────────────────────────────────────────────────────────┘ 51/60 DAYO AP, TJS LAB Page: 86 - To edit a memo field, just highlight the field, and start typing. * * * To save your work, once finished, YOU MUST PRESS Ctrl W UPON EXITING! ┌────────────────────────────────[ BROWSE SDF ]──────────────────────────────┐ │ PRICE LIST YOURPART NOTES │ │───────────────────────╥────────────╥─────────────────╥─────────────────────│ │ 896.16 ║ 1792.32 ║ ║ <Memo> │ │ 1064.19 ║ 2128.38 ║ ║ <Memo> │ │ 672.12 ║ 1344.24 ║ ║ <Memo> │ │ 1736.31 ║ 3472.62 ║ ║ <Memo> │ │ 504.09 ║ 1008.18 ║ ║ <Memo> │ │ 784.14 ║ 1568.28 ║ ║ <Memo> │ │ 1400.25 ║ 2800.50 ║ ║ <Memo> │ ┌────────────────────────────[ Edit Field: NOTES ] ──────────────────────────┐ │You can edit memo fields too... │ │ │ │ │ │ │ │ │ │ │ │ │ └───────────────────────[ Esc (ABORT) Ctrl W (SAVE) ]─────────────────────┘ │ Esc(EXIT) Ctrl N(ADD) Ctrl U(DELETE) F5(Find) │ └────────────────────────────────────────────────────────────────────────────┘ - Special keys for 'moving around' the BROWSE screen are: Left Arrow Key - Move to next field to your left Right Arrow Key - Move to next field to your right Ctrl Home - Go to the leftmost field Ctrl End - Go to the rightmost field (on the end of the record) Up Arrow - Move highlight to the previous record Down Arrow - Move highlight to the next record PgUp - Page up a full screen of records PgDn - Page down a full screen of records Ctrl PgUp - Go to the beginning of the file Ctrl PgDn - Go to the end or last record of the file Ctrl N - Add a record (where applicable) Ctrl U - Delete a record (where applicable) F5 - To seek/find a record based upon the active index Esc - Exit the current operation - Remember that there are many more fields to the right of the screen. Press the right arrow key to view them... DAYO AP, TJS LAB Page: 87 ■ COPY (.DBF) TO - Copy records to another (new) database. Use this option to copy select records into a new database or ASCII (SDF and DELIMITED) file. COPY TO can also be used to create backups of data (EG: copy to floppy). ┌─────────────────────────────[ COPY (.DBF) TO ]─────────────────────────────┐ │ │ │ Enter Database Name To COPY FROM: │ │ Enter┌────────[ PICK A DATABASE ]───────────┐y... │ │ │ FILE NAME SIZE DATE USED│ │ │ ├──────────────┬────────────┬──────────┤ │ │ │HARPS.DBF │ 375 │ 09/16/89 │ │ │ │INVENT.DBF │ 7335 │ 09/16/89 │ │ │ │SDFSTUF.DBF │ 103 │ 09/16/89 │ │ │ │MORETRAH.DBF │ 24387 │ 09/16/89 │ │ │ │AP.DBF │ 289 │ 09/16/89 │ │ │ └──────────────┴────────────┴──────────┘ │ │ ┌───────────────────────┐│ │ │ Highlight a database ││ │ │ using the ││ │ │ arrow keys, then press││ │ │ Enter/Return. ││ │ └───────────────────────┘│ └────────────────────────────────────────────────────────────────────────────┘ - The next prompt will be to select the type of COPY TO option you want: ┌──────────────────────────────[ COPY (.DBF) TO ]────────────────────────────┐ │ │ │ Enter Database Name To COPY FROM: INVENT.DBF │ │ Enter Nothing For Listing Of Current Directory... │ │ │ │ │ │ Type of Copy To: Standard SDF DELIMITED STRUCTURE │ │ │ │ │ │ Copy Records From INVENT.DBF │ └────────────────────────────────────────────────────────────────────────────┘ - The Standard option is simply creating another database (.DBF). The SDF and DELIMITED options will create ASCII files. The STRUCTURE option creates a new database with the same file structure as the initial database (no records copied). DAYO AP, TJS LAB Page: 88 - The next prompt (optional), requires some knowledge of dBase (tm). This prompt is requesting the user to enter a condition or filter. If all records are to be copied, just press Enter on an empty prompt. ┌╔═══════════════════════════[ FIELD NAMES & TYPE ]═════════════════════════╗┐ │║ ║│ │║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║│ │║NOTES{M} ■ ║│ │╚══════════════════════════════════════════════════════════════════════════╝│ │ │ │ │ │ Type of Copy To: Standard SDF DELIMITED STRUCTURE │ │ │ │ Enter SDF File Name To Copy Data TO: NEW.DBF │ │ │ │ Enter Condition: │ │ Sample condition: COST > 100 │ │ │ │ │ │ Copy Records From NEW │ └────────────────────────────────────────────────────────────────────────────┘ - This 'Condition' option is useful for coping only specific records into a new location. Any valid dBase/Clipper statement (as shown next) is fine... ┌╔═══════════════════════════[ FIELD NAMES & TYPE ]═════════════════════════╗┐ │║ ║│ │║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║│ │║NOTES{M} ■ ║│ │╚══════════════════════════════════════════════════════════════════════════╝│ │ │ │ Type of Copy To: Standard SDF DELIMITED STRUCTURE │ │ │ │ Enter SDF File Name To Copy Data TO: NEW DBF │ │ │ │ Enter Condition: PRICE>0 │ │ Sample condition: COST > 100 │ │ │ │ Copy Records From NEW │ └────────────────────────────────────────────────────────────────────────────┘ DAYO AP, TJS LAB Page: 89 - The following window message will appear while the COPY TO routine does its task: ┌╔═══════════════════════════[ FIELD NAMES & TYPE ]═════════════════════════╗┐ │║ ║│ │║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║│ │║NOTES{M} ■ ║│ │╚══════════════════════════════════════════════════════════════════════════╝│ │ │ │ Type of Copy To: Standard SDF DELIMITED STRUCTURE │ │ │ │ Enter SDF File Name To Copy Data TO: NEW10 │ │ │ │ Enter Condition: PRICE>0 │ │ Sample cond┌───────────────────────────────────────────────┐ │ │ │┌─────────────────────────────────────────────┐│ │ │ CONDITION: ││┌───────────────────────────────────────────┐││ │ │ │││┌─────────────────────────────────────────┐│││ │ │ ││││Hold those camels while I do this COPY TO││││ │ │ │││└─────────────────────────────────────────┘│││ │ │ ││└───────────────────────────────────────────┘││ │ │ │└─────────────────────────────────────────────┘│ │ │ └───────────────────────────────────────────────┘ │ │ Copy Records From SDF To NEW10 │ └────────────────────────────────────────────────────────────────────────────┘ ■ CREATE DATABASE - Create a new database. This routine lets you create entirely new database structures. At the FIELD_NAME field, enter a unique field name. At the FIELD_TYPE field, enter a 'C' for character, 'N' for numeric, 'D' for Date, 'L' for logical or 'M' for memofield. At the FIELD_LEN field, enter the size/length of the character and/or numeric field. At the FIELD_DEC field, enter the number of decimals for the numeric field. ┌───────[ CREATE A NEW DATABASE: NEW.DBF ]────────┐ │ FIELD_NAME FIELD_TYPE FIELD_LEN FIELD_DEC │ │────────────╥────────────╥───────────╥───────────│ │ ║ ║ 0 ║ 0 │ │ ║ ║ ║ │ │ ║ ║ ║ │ ┌─────────────│ ║ ║ ║ │────────────┐ │ │ ║ ║ ║ │ │ │ ENTER TH│ ║ ║ ║ │ │ │ │ ║ ║ ║ │ │ └─────────────│ ║ ║ ║ │────────────┘ │────────────╨────────────╨───────────╨───────────│ │ Press Enter to edit any field... │ └──────[ PRESS Ctrl W TO SAVE AND EXIT ]────────┘ DAYO AP, TJS LAB Page: 90 * * * TO EDIT ANY FIELD, YOU MUST PRESS Enter FIRST * * * IT IS SLIGHTLY BOTHERSOME SORRY! WANT YOU TO THINK ABOUT WHAT YOU ARE DOING... *** If any error is made in this routine, you will experience an error, either immediately, or when you start to edit the new database. This error may even cause your computer to hang! *** Be sure to Press: Ctrl W when you are finished and satisfied. Pressing Esc will just negate your efforts.. ┌───────[ CREATE A NEW DATABASE: NEW.DBF ]────────┐ │ FIELD_NAME FIELD_TYPE FIELD_LEN FIELD_DEC │ │────────────╥────────────╥───────────╥───────────│ │ NAME ║ C ║ 30 ║ 0 │ │ AGE ║ N ║ 5 ║ 1 │ │ DEAD ║ L ║ 1 ║ 0 │ │ BIRTHDATE ║ D ║ 8 ║ 0 │ ┌─────────────│ REMARKS ║ M ║ 10 ║ 0 │────────────┐ │ │ ║ ║ 0 ║ 0 │ │ │ ENTER TH│ ║ ║ ║ │ │ │ │ ║ ║ ║ │ │ │ │ ║ ║ ║ │ │ └─────────────│ ║ ║ ║ │────────────┘ │ ║ ║ ║ │ │────────────╨────────────╨───────────╨───────────│ │ Press Enter to edit any field... │ └──────[ PRESS Ctrl W TO SAVE AND EXIT ]────────┘ DAYO AP, TJS LAB Page: 91 ■ DELETE RECORDS - Delete selected records from databases. The first prompt is for the name of the database you wish to mark records for deletion. Like many of the other routines, you can press enter on an empty prompt to bring up all databases that exist in the current directory: ┌────────[ PICK A DATABASE ]───────────┐ │ FILE NAME SIZE DATE USED│ ├──────────────┬────────────┬──────────┤ │D.DBF │ 259 │ 09/16/89 │ │DDD.DBF │ 375 │ 09/16/89 │ │NEW.DBF │ 195 │ 09/17/89 │ │SDF.DBF │ 7335 │ 09/16/89 │ │TRASH.DBF │ 24387 │ 09/16/89 │ │XXX.DBF │ 289 │ 09/16/89 │ ┌────────────────────────┐ └──────────────┴────────────┴──────────┘ │ Highlight a database │ │ using the │ ┌────────────────────────[ DELETE SELECTED RECORDS ]│ arrow keys, then press │ │ Enter Database Name: │ Enter/Return. │ │ └────────────────────────┘ │ │ └────────────────────────────────────────────────────────────────────────────┘ - After selecting the database, all its fields will be presented atop the screen so as to aid the user in entering a condition/filter. The use of the condition prompt is NOT optional, so some knowledge of dBase/Clipper syntax is required. Note the use of the Clipper Function: EMPTY(). ╒╔═══════════════════════════[ FIELD NAMES & TYPE ]══════════════════════════╗ │║ ║ ╘║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║ ║NOTES{M} ■ ║ ╚═══════════════════════════════════════════════════════════════════════════╝ ┌────────────────────────[ DELETE SELECTED RECORDS ]─────────────────────────┐ │ Enter Database Name: TRASH │ │ Delete Records For Condition: EMPTY(PART) │ │ Sample condition: COST > 100 │ │ CONDITION: EMPTY(PART) │ │ Number of Records Deleted: 208 │ │ Press any key to continue... │ └────────────────────────────────────────────────────────────────────────────┘ - The number of records deleted will be displayed upon the screen as depicted just above... DAYO AP, TJS LAB Page: 92 ■ ERASE FILE - Erase a file (forever!). Use this option with extreme care! Again, be careful! ANY FILE SELECTED WITH THIS OPTION WILL BE PERMANENTLY REMOVED FROM EXISTENCE NO SECOND CHANCES HERE... - The first prompt is for the file name. You can press enter on an empty prompt to bring up a window selection of all files in the current directory. ┌────────────────────────┐ ┌────────[ ERASE THE FILE ]────────────┐ │ Highlight a file │ │ FILE NAME SIZE DATE USED│ │ using the │ ├──────────────┬────────────┬──────────┤ │ arrow keys, then press │ │B.BAT │ 222 │ 09/16/89 │ │ Enter/Return. │ │BKDOOR.$$$ │ 8192 │ 09/16/89 │ └────────────────────────┘ │BKDOOR.DOC │ 37029 │ 09/17/89 │ │BKDOOR.ZIP │ 19415 │ 09/16/89 │ │D.DBF │ 259 │ 09/16/89 │ │D.DBT │ 512 │ 09/16/89 │ │DAYOBK.BAK │ 36879 │ 09/16/89 │ │DAYOBK.LIB │ 36879 │ 09/16/89 │ │DAYOBK.LST │ 2056 │ 09/16/89 │ │DAYOBK.OBJ │ 35585 │ 09/16/89 │ │DAYOCAL.MAP │ 35 │ 09/16/89 │ │DDD.DBF │ 375 │ 09/16/89 │ │DDD.DBT │ 512 │ 09/16/89 │ │DDD.NTX │ 2048 │ 09/16/89 │ │DEMO.EXE │ 245404 │ 09/16/89 │ └──────────────┴────────────┴──────────┘ More - To ERASE a file, just highlight it, then press Enter... ■ EXIT TO DOS - This option will close all open files and databases and exit to DOS without having to return to the main menu exit routine. DAYO AP, TJS LAB Page: 93 ■ INDEX A DATABASE - You will be prompted to select the database you wish to index. After selecting the database, by typing in the name or pressing Enter on an empty prompt (then selecting from the window), you will be given a listing of all fields in that database atop the screen. ┌────────[ PICK A DATABASE ]───────────┐. │ FILE NAME SIZE DATE USED│ ├──────────────┬────────────┬──────────┤ │DAD.DBF │ 259 │ 09/16/89 │ │NEW.DBF │ 195 │ 09/17/89 │ │SPW.DBF │ 7335 │ 09/16/89 │ │SOW.DBF │ 103 │ 09/16/89 │ │BOY.DBF │ 24387 │ 09/17/89 │ │SHI.DBF │ 289 │ 09/16/89 │ ┌────────────────────────┐ └──────────────┴────────────┴──────────┘ │ Highlight a database │ │ using the │ ┌───────────────────[ INDEX A DATABASE ]───│ arrow keys, then press │ │ Enter Database Name: │ Enter/Return. │ │ └────────────────────────┘ └───────────────────────────────────────────────────────────────┘ - You will now be prompted to enter the name of the Index File. It will be (by default), named exactly the same as the selected database, with the exception of the extension. This will default to .NDX or .NTX depending on whether you linked NDX.OBJ with your application. *** Remember that the BROWSE routine only looks at indexes with the same name as the database. ╒╔═══════════════════════════[ FIELD NAMES & TYPE ]══════════════════════════╗ │║ ║ ╘║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║ ║NOTES{M} ■ ║ ╚═══════════════════════════════════════════════════════════════════════════╝ ┌───────────────────[ INDEX A DATABASE ]────────────────────────┐ │ Enter Name of Index File: TRASH.NTX │ └───────────────────────────────────────────────────────────────┘ DAYO AP, TJS LAB Page: 94 - At the prompt for the index key, enter a field name, or a valid dBase/Clipper expression. ╒╔══════════════════════════[ FIELD NAMES & TYPE ]═══════════════════════════╗ │║ ║ ╘║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║ ║NOTES{M} ■ ║ ╚═══════════════════════════════════════════════════════════════════════════╝ ┌───────────────────[ INDEX A DATABASE ]────────────────────────┐ │ Enter Name of Index File: TRASH.NTX │ │ Enter the Key Expression: PART+MFG_PART │ └───────────────────────────────────────────────────────────────┘ ■ LIST FIELDS - List fields to screen or printer. This routine is a great tool for providing simple reports and lists. The first prompt will be for the database you wish to work with. Type the name of the file, or press Enter on an empty prompt to bring up a window of all databases in the current directory for selection. ┌────────[ PICK A DATABASE ]───────────┐ │ FILE NAME SIZE DATE USED│ ├──────────────┬────────────┬──────────┤ │INVEND.DBF │ 259 │ 09/16/89 │ │INVENT.DBF │ 375 │ 09/16/89 │ │NEW.DBF │ 195 │ 09/17/89 │ │SOMEDAY.DBF │ 7335 │ 09/16/89 │ │TANGO.DBF │ 103 │ 09/16/89 │ │AP.DBF │ 24387 │ 09/17/89 │ │BACKUP.DBF │ 289 │ 09/16/89 │ ┌────────────────────────┐ └──────────────┴────────────┴──────────┘ │ Highlight a database │ │ using the │ ┌──────────────────────────────────────────│ arrow keys, then press │ │ Enter Database Name: │ Enter/Return. │ │ └────────────────────────┘ └───────────────────────────────────────────────────────────────┘ DAYO AP, TJS LAB Page: 95 - The next prompt is for a condition or filter. This makes it possible to list only specific records that meet that condition you enter. The condition must be a valid dBase/Clipper expression, or none (to list all). ╒╔══════════════════════════[ FIELD NAMES & TYPE ]═══════════════════════════╗ │║ ║ ╘║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║ ║NOTES{M} ■ ║ ╚═══════════════════════════════════════════════════════════════════════════╝ ┌─────────────────────────────────────────────────────┐ │ Enter Filter: │ │ EG: ID = "SAM0909" .AND. RETAIL > 10000 │ └─────────────────────────────────────────────────────┘ ┌───────────────────────────────────────────────────────────────┐ │ Enter Database Name: │ │ │ └───────────────────────────────────────────────────────────────┘ - A window box appears next displaying all the fields in the selected database and an option to list all fields. Highlight any combination of fields ( or ALL) that you want listed. ╒╔═┌─────────────────┐═══════[ FIELD NAMES & TYPE ]══════════════════════════╗ │║ │ PICK THE FIELDS │ ║ ╘║P│ YOU WANT LISTED │} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║ ║ ├─────────────────┤ ║ ╚═│■■ ALL ■■ │═══════════════════════════════════════════════════════╝ │RECNO() │ │MFG_PART │ │PRICE │ │YOURPART │ ┌────────────────────────────────────────────────────┐ │NOTES │ │ Enter Filter: │ ├─────────────────┤ │ EG: ID = "SAM0909" .AND. RETAIL > 10000 │ │PRESS Esc TO EXIT│ └────────────────────────────────────────────────────┘ └─────────────────┘────────────────────────────────────────────────────┐ │ Enter Database Name: │ └───────────────────────────────────────────────────────────────┘ DAYO AP, TJS LAB Page: 96 - The fields you select will be displayed at center top of screen. Press Esc to exit the "PICK THE FIELDS YOU WANT LISTED" window. ╒╔═┌─────────────────┐═══════[ FIELD NAMES & TYPE ]══════════════════════════╗ │║ │ PICK THE FIELDS │ ║ ╘║P│ YOU WANT LISTED │} ■ DES┌────────────────────┐{N} ■ YOURPART{C} ■ ║ ║N├─────────────────┤ │PART │ ║ ╚═│■■ ALL ■■ │═══════│MFG_PART │══════════════════════════╝ │RECNO() │ │PRICE │ │PART │ └────────────────────┘ │PRICE │ │YOURPART │ ┌────────────────────────────────────────────────────┐ │NOTES │ │ Enter Filter: │ ├─────────────────┤ │ EG: ID = "SAM0909" .AND. RETAIL > 10000 │ │PRESS Esc TO EXIT│ └────────────────────────────────────────────────────┘ └─────────────────┘────────────────────────────────────────────────────┐ │ Enter Database Name: │ └───────────────────────────────────────────────────────────────┘ - At the next prompt, you can send the list to the SCREEN, PRINTER OR FILE. ╒╔═┌─────────────────┐═══════[ FIELD NAMES & TYPE ]══════════════════════════╗ │║ │ PICK THE FIELDS │ ║ ╘║P│ YOU WANT LISTED │} ■ DES┌────────────────────┐{N} ■ YOURPART{C} ■ ║ ║N├─────────────────┤ │PART │ ║ ╚═│■■ ALL ■■ │═══════│MFG_PART │══════════════════════════╝ │RECNO() │ │PRICE │ │PART │ └────────────────────┘ │DESC┌──────────────────────────────────────────────────────────────────┐ │PRIC│ Do you want to print the list to the SCREEN or PAPER or FILE ? │ │LIST│ │ │YOUR└──────────────────────────────────────────────────────────────────┘─┐ │NOTES │ │ Enter Filter: │ ├─────────────────┤ │ EG: ID = "SAM0909" .AND. RETAIL > 10000 │ │PRESS Esc TO EXIT│ └────────────────────────────────────────────────────┘ └─────────────────┘────────────────────────────────────────────────────┐ │ Enter Database Name: │ └───────────────────────────────────────────────────────────────┘ DAYO AP, TJS LAB Page: 97 - The list is very simple, and if displayed onto the screen, may look like the following: PART MFG_PART PRICE 4523 0.00 DAYO9S 41926 1904.34 DAYO10S 13564 616.11 DAYOCOMP 45625 2072.37 DAYOALLS 43159 1960.35 INDEXER 50558 2296.41 INDEXERS 51791 2352.42 5 DEMO 4932 224.04 DAYO13S 20963 952.17 MENUS 53024 2408.43 OFFSITEP 56724 2576.46 ONSITEP 57957 2632.47 DAYO2S 24662 1120.20 DAYO9 40693 1848.33 DAYO10 12331 560.10 DAYOCAL$ 44392 2016.36 DAYO13 19730 896.16 DAYO2 23429 1064.19 DAYO11 14797 672.12 DAYO8 38227 1736.31 DAYO1 11098 504.09 DAYO12 17264 784.14 DAYO5 30828 1400.25 ......PRESS ANY KEY TO CONTINUE...... ■ MODIFY DATABASE - Change the fields/structure of a database. You can add new fields, delete fields, change the length and type of field in any of the databases. At the FIELD_NAME field, enter a unique field name. At the FIELD_TYPE field, enter a 'C' for character, 'N' for numeric, 'D' for Date, 'L' for logical or 'M' for memofield. At the FIELD_LEN field, enter the size/length of the character and/or numeric field. At the FIELD_DEC field, enter the number of decimals for the numeric field. ******************************************************** *** TO EDIT ANY FIELD, YOU MUST PRESS Enter FIRST *** *** IT IS SLIGHTLY BOTHERSOME SORRY! *** ******************************************************** *** If any error is made in this routine, you will experience an error, either immediately, or when you start to access the database. This error may even cause your computer to hang! DAYO AP, TJS LAB Page: 98 *** Be sure to Press: Ctrl W when you are finished and satisfied. Pressing Esc will just negate your efforts.. ■ PACK DATABASE - Pack a database (removed deleted records). This option will permanently remove any records marked for deletion. This is another routine you should use with great care! As in many of the other of the routines, you will be prompted to enter the name of the database you wish to pack. Enter the name or press Enter on an empty prompt to view the window. ┌─────┐ │PACK!│ └─────┘ ┌────────[ PICK A DATABASE ]───────────┐ │ FILE NAME SIZE DATE USED│ ├──────────────┬────────────┬──────────┤ │GOODDATA.DBF │ 259 │ 09/16/89 │ │HAP.DBF │ 375 │ 09/16/89 │ │NEW.DBF │ 195 │ 09/17/89 │ │SDF.DBF │ 7335 │ 09/16/89 │ │LOIN.DBF │ 103 │ 09/16/89 │ │TRASH.DBF │ 24387 │ 09/17/89 │ │FIX.DBF │ 289 │ 09/16/89 │ ┌────────────────────────┐ └──────────────┴────────────┴──────────┘ │ Highlight a database │ │ using the │ ┌──────────────────────────────────────────│ arrow keys, then press │ │ Enter Database Name: │ Enter/Return. │ └──────────────────────────────────────────└────────────────────────┘ - After selecting the database, you will be prompted to respond with a Yes or No (to Pack or not to Pack...). This is the last chance you have to change your mind... ┌──────────────────────────────────────────────────────────────────────────┐ │ PACK TOM3 │ │ Are you sure you want to PACK (remove deleted records) ? N │ └──────────────────────────────────────────────────────────────────────────┘ │ Enter Database Name: │ └───────────────────────────────────────────────────────────────┘ DAYO AP, TJS LAB Page: 99 ■ RECALL RECORDS - Recalls records previously marked for deletion. This option is identical to the DELETE RECORDS option discussed earlier... ■ RETURN TO MENU - Returns to the procedure that called MISC Routines. ■ RUN (DOS COMMAND) - Run a DOS command (EG: dir/w). This option is helpful in that it allows you to run programs at the DOS level (within memory constraints). ┌───────────────────────────────────────────────────────────────────────────┐ │ RUN CD\DOS │ └───────────────────────────────────────────────────────────────────────────┘ - One useful option is to type and Enter: COMMAND at this prompt. You will be running another DOS Shell totally out of the program (it still is in memory though). ┌───────────────────────────────────────────────────────────────────────────┐ │ RUN COMMAND │ └───────────────────────────────────────────────────────────────────────────┘ - Press and Enter: EXIT to return to your Clipper Application. EG: The COMPAQ Personal Computer MS-DOS Version 3.31 (C) Copyright Compaq Computer Corp. 1982, 1987 (C) Copyright Microsoft Corp. 1981, 1987 C:\KISBBS>EXIT DAYO AP, TJS LAB Page: 100 ■ SIMPLE EDITOR - A simple editor and word processor. Use this option to create and read simple TEXT files. File size is limited to your machines capabilities or 32,000k. The first prompt is for the name of the file you wish to edit. Type in the name, or press Enter on an empty prompt to bring up a window option box containing all files in the current directory. ┌────────────────────────┐ ┌──────────[ EDIT THE FILE ]───────────┐ │ Highlight a file │ │ FILE NAME SIZE DATE USED│ │ using the │ ├──────────────┬────────────┬──────────┤ │ arrow keys, then press │ │B.BAT │ 222 │ 09/16/89 │ │ Enter/Return. │ │BKDOOR.DOC │ 56356 │ 09/17/89 │ └────────────────────────┘ │BKDOOR.ZIP │ 19415 │ 09/16/89 │ │DAYOBK.LIB │ 36879 │ 09/16/89 │ │DAYOBK.LST │ 2056 │ 09/16/89 │ ┌────────│DAYOBK.OBJ │ 35585 │ 09/16/89 │────────────────────────────┐ │ Enter t│DAYOCAL.MAP │ 35 │ 09/16/89 │ │ │ Press E│DDD.DBF │ 375 │ 09/16/89 │urrent directory listing. │ └────────│DDD.DBT │ 512 │ 09/16/89 │────────────────────────────┘ │DDD.NTX │ 2048 │ 09/16/89 │ │DEMO.EXE │ 245404 │ 09/16/89 │ │DEMO.MAP │ 7780 │ 09/16/89 │ └──────────────┴────────────┴──────────┘ More - *** Note, this routine will try to load binary files (.EXE, .OBJ, .etc...), so be careful at what you select for viewing/editing. - If you make ANY changes to the file, You MUST PRESS Ctrl W to SAVE those changes. If you exit with an Esc, all changes will be lost! ┌──────────────────────────────[ SIMPLE EDITOR ]─────────────────────────────┐ │CLIPPER demo │ │CLIPPER MISC │ │KWAIT 10 │ │LIB MISC-+MISC,MISC.LST,MISC │ │KWAIT 10 │ │TLINK DEMO,,,MISC \CLIPPER\CLIPPER \CLIPPER\EXTEND │ │KWAIT 10 │ │DEMO │ └────────────────────────────────────────────────────────────────────────────┘ Esc (ABORT) Ctrl W (SAVE) Initial Size: 222 1/0 DAYO AP, TJS LAB Page: 101 - Special keys for 'moving around' the SIMPLE EDITOR screen are: Left Arrow Key - Move to your left Right Arrow Key - Move to your right Ctrl Home - Go to the top, leftmost corner of window Ctrl End - Go to the bottom, rightmost corner of window Up Arrow - Move up one line Down Arrow - Move down one line PgUp - Page up a full screen PgDn - Page down a full screen Ctrl PgUp - Go to the beginning of the file Ctrl PgDn - Go to the end of the file * F2 - Import text from a text file * Ctrl W - Save Changes and Exit * Esc - ABORT Changes and Exit The margin may exceed the boundaries on the right side of the screen, but the text is easily accessed using the special keys above... ■ SORT DATABASE - This option takes a database, sorts it, and copies the result into a new database. The first prompt is for the name of the database you want to sort. Enter the name, or press Enter on an empty prompt to bring up a window box containing all databases in the current directory. ┌────────[ PICK A DATABASE ]───────────┐ │ FILE NAME SIZE DATE USED│ ├──────────────┬────────────┬──────────┤ │DOG.DBF │ 259 │ 09/16/89 │ │CAT.DBF │ 375 │ 09/16/89 │ │CAR.DBF │ 195 │ 09/17/89 │ │BAM.DBF │ 7335 │ 09/16/89 │ │HARP.DBF │ 103 │ 09/17/89 │ │TRAIN.DBF │ 24387 │ 09/17/89 │ │HIPPY.DBF │ 289 │ 09/16/89 │ ┌────────────────────────┐ └──────────────┴────────────┴──────────┘ │ Highlight a database │ │ using the │ ┌───────────────────[ SORT A DATABASE ]────│ arrow keys, then press │ │ Enter Database Name: │ Enter/Return. │ │ └────────────────────────┘ │ │ └───────────────────────────────────────────────────────────────┘ DAYO AP, TJS LAB Page: 102 - The next prompt is for the name of the database you will be creating with the sorted data. ╒╔═══════════════════════════[ FIELD NAMES & TYPE ]══════════════════════════╗ │║ ║ ╘║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║ ║NOTES{M} ■ ║ ╚═══════════════════════════════════════════════════════════════════════════╝ ┌───────────────────[ SORT A DATABASE ]─────────────────────────┐ │ Enter Database Name: INVNET.DBF │ │ Enter Name of Sorted File: INVNET1.DBF │ │ │ └───────────────────────────────────────────────────────────────┘ - The next prompt is for the sort field (limited to 1 field)... ╒╔═════════════════════════[ FIELD NAMES & TYPE ]═══════════════════════════╗ ╘║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║ ║NOTES{M} ■ ║ ╚══════════════════════════════════════════════════════════════════════════╝ ┌───────────────────[ SORT A DATABASE ]─────────────────────────┐ │ Enter Database Name: TOM.DBF │ │ Enter Name of Sorted File: TOM1.DBF │ │ Enter the Key Expression: PART │ └───────────────────────────────────────────────────────────────┘ ■ TYPE (PRINT) FILE - Prints an ASCII/text file to screen or printer. The first prompt is for the file name. ┌───────────────────────[ TYPE TO SCREEN OR PRINTER ]────────────────────────┐ │ Enter the ASCII/TEXT file to TYPE: KISBBS.DOC │ │ Press Enter/Return on an empty field to get a current directory listing. │ └────────────────────────────────────────────────────────────────────────────┘ DAYO AP, TJS LAB Page: 103 - The display of the file (any type), is continuous, but can be paused by any key (except the Enter & Esc keys). Pressing the Enter key will slow the printing of the file onto the screen. Press Esc to Abort the display... A sample display: FUNCKEY...........MISC FUNIQUE...........MISC FZAP..............MISC GET_PIC1..........MISC ISDATA............MISC ISDBF.............MISC MENU_KEY..........MISC MISC..............MISC OKFILE............MISC PACKIT............MISC PICKDBF...........MISC PROCLIST..........MISC SHOW_INS2.........MISC STATLINE2.........MISC TOG_INS2..........MISC XKEY_CLEAR........MISC XKEY_NORM.........MISC XMEMO.............MISC MISC BKDOOR BROWSEIT CENTER1 COLORSET DBFUNCT DBFUNCT6 EDITOR FACHOICE FAPPEND FCOPY2 FDBF1 FDELETE FERASE FILESZ FILE_UDF FILT FINDER FINDEX FMAKEDB FMODYDB FNEW FRECALL FRUN FSCROLL1 FSORT FTYPEIT FUNCKEY FUNIQUE FZAP GET_PIC1 ISDATA ISDBF MENU_KEY MISC OKFILE PACKIT PICKDBF PROCLIST SHOW_INS2 STATLINE2 TOG_INS2 XKEY_CLEAR XKEY_NORM XMEMO PRESS ANY KEY TO CONTINUE... ■ ZAP DATABASE - Totally erase all records in database (forever!). When you want to remove every record from a database, then use this option. Use with EXTREME CAUTION! The first prompt is for the file name. Enter the name of the database you are to 'clean out', or press Enter to select the database from a window containing all databases in the current directory. DAYO AP, TJS LAB Page: 104 ┌────┐ │ZAP!│ └────┘ ┌────────[ PICK A DATABASE ]───────────┐ │ FILE NAME SIZE DATE USED│ ├──────────────┬────────────┬──────────┤ │DENVER.DBF │ 259 │ 09/16/89 │ │OHIO.DBF │ 375 │ 09/16/89 │ │NEWYORK.DBF │ 195 │ 09/17/89 │ │MONTANA.DBF │ 7335 │ 09/16/89 │ │SC.DBF │ 259 │ 09/17/89 │ │EARS.DBF │ 103 │ 09/17/89 │ │FRUIT.DBF │ 24387 │ 09/17/89 │ ┌────────────────────────┐ │MATH.DBF │ 259 │ 09/17/89 │ │ Highlight a database │ │CARROTS.DBF │ 289 │ 09/16/89 │ │ using the │ └──────────────┴────────────┴──────────┘───│ arrow keys, then press │ │ Enter Database Name: │ Enter/Return. │ └──────────────────────────────────────────└────────────────────────┘ - You will be prompted one last time as to whether you still want to ZAP the selected database. Press Y for Yes, N for No... ┌────┐ │ZAP!│ └────┘ ┌──────────────────────────────────────────────────────────────────────────┐ │ ZAP TRASH │ │ Are you sure you want to ZAP (remove all records permanently) ? N │ │ │ └──────────────────────────────────────────────────────────────────────────┘ │ Enter Database Name: │ └───────────────────────────────────────────────────────────────┘ DAYO AP, TJS LAB Page: 105 ■ HELP SCREENS - While in the browse screens, some of the option windows, and in the SIMPLE EDITOR, pressing the F1 key, will display a help screen. - BROWSE help: ┌──────────────────────[ DAYOAP HELP: DBEDIT, 0, ]──────────────────────────┐ │ │ │- Special keys for 'moving around' the BROWSE screen are: │ │ │ │ Left Arrow Key - Move to next field to your left │ │ Right Arrow Key - Move to next field to your right │ │ Ctrl Home - Go to the leftmost field │ │ Ctrl End - Go to the rightmost field (on the end of the record)│ │ Up Arrow - Move highlight to the previous record │ │ Down Arrow - Move highlight to the next record │ │ PgUp - Page up a full screen of records │ │ PgDn - Page down a full screen of records │ │ Ctrl PgUp - Go to the beginning of the file │ │ Ctrl PgDn - Go to the end or last record of the file │ │ Ctrl N - Add a record (where applicable) │ │ Ctrl U - Delete a record (where applicable) │ │ F5,F6,F7 - To seek/find a record based upon the active index │ │ Esc - Exit the current operation │ │ │ │ Remember that there are many more fields to the right of the screen. │ │ Press the right arrow key to view them... │ └────────────────────────────────────────────────────────────────────────────┘ - Option Box Help: ┌────────────────────────[ DAYOAP HELP: ACHOICE, 0, ]───────────────────────┐ │ │ │ │ │ │ │ │ │ - Special keys for 'moving around' the Option Box are: │ │ │ │ Up Arrow - Move up one option │ │ Down Arrow - Move down one option │ │ PgUp - Page up multiple records │ │ PgDn - Page down multiple records │ │ Esc - ABORT and Exit │ │ │ │ │ │ After highlighting the option you desire, press Enter... │ │ │ │ │ │ │ └────────────────────────────────────────────────────────────────────────────┘ DAYO AP, TJS LAB Page: 106 - Editor help: ┌───────────────────────[ DAYOAP HELP: MEMOEDIT, 0, ]───────────────────────┐ │ │ │ - Special keys for 'moving around' the EDITOR screen are: │ │ │ │ Left Arrow Key - Move to your left │ │ Right Arrow Key - Move to your right │ │ Ctrl Home - Go to the top, leftmost corner of window │ │ Ctrl End - Go to the bottom, rightmost corner of window │ │ Up Arrow - Move up one line │ │ Down Arrow - Move down one line │ │ PgUp - Page up a full screen │ │ PgDn - Page down a full screen │ │ Ctrl PgUp - Go to the beginning of the file │ │ Ctrl PgDn - Go to the end of the file │ │ Ctrl W - SAVE Changes and Exit │ │ Esc - ABORT Changes and Exit │ │ F2 - Import another text file into your document │ │ │ │ The margin may exceed the boundaries on the right side of the screen, │ │ but the text is easily accessed using the special keys above... │ │ │ │ │ └────────────────────────────────────────────────────────────────────────────┘ - Recurring Check Browse Help: DAYO AP Version 4.0 TJS LAB CHECKS ┌───[February 1992]──┐ ┌─────────────────[ DAYO AP - RECURRING CHECK BROWSE HELP ]──────────────────┐ │ │ │ SCHEDULE CODES For Scheduling Recurring Checks To Become 'DUE': │ │ SUNDAY Only on a Sunday │ │ MONDAY Only on a Monday │ │ TUESDAY Only on a Tuesday │ │ WEDNESDAY Only on a Wednesday │ │ THURSDAY Only on a Thursday │ │ FRIDAY Only on a Friday │ │ SATURDAY Only on a Saturday │ │ MM/DD/YY On a Specific Date (ie: '01/31/91' for January 31, 1991) │ │ DAYSxxx Every Few Days, (ie: 'DAYS 21' for every 21 days) │ │ SEMIMONTH Every 2 Weeks │ │ MIDMONTH Mid Month │ │ EOM End of Month │ │ BEGMONTH Beginning of the Month │ │ BIMONTH Every 2 Months (60 Days) │ │ QUARTERLY Every Quarter (90 Days) │ │ ANNUAL Once a Year │ └────────────────────────────────────────────────────────────────────────────┘ DAYO AP, TJS LAB Page: 107 ■ EXPANDED HELP After Version 1.3, expanded help routines were added to all DAYO modules. At almost all prompts and menus you can press F1 for help. Help can be a function key message as displayed on previous page, a message that you have created (user defined & inputted), or the ability to read the documentation on the screen (saves paper). ■ USER DEFINED & INPUTTED HELP SCREENS/MESSAGES If you press F1 and no user defined & inputted message exists for that section of the program you are currently in you will receive a message to this effect, and then a blank/empty screen. The editing keys for this option are the same as for the Simple Editor (previous page). DAYO AP Version 4.0 TJS LAB ┌───[February 1992]──┐ ┌──────[ DAYO HELP Called by Program: DAYOAP Variable: OPT ]───────┐ │ │ │ │ │ │ │ │ │ │ │ │ │ ╔════════════════════════════════════════════════════════╗ │ │ ║ No Online Help Messages Exist for this prompt... ║ │ │ ║ ║ │ │ ║ You can type in any help message you wish, or ║ │ │ ║ press F1 to view the document for DAYOAP. ║ │ │ ║ ║ │ │ ║ ║ │ │ ║ Press any key to continue... ║ │ │ ╚════════════════════════════════════════════════════════╝ │ │ │ │ │ ├───────────────────────────────────────────────────────────────────────────┤ │ Esc (Exit) Ctrl W (Save Changes) F1 (Read Manual) │ └───────────────────────────────────────────────────────────────────────────┘ If you wish to input anything at this point, just type whatever you wish, remembering to press Ctrl W to save all changes. Pressing Esc will not save ANY changes ( all effort you put into writing a help message will be lost! ). DAYO AP, TJS LAB Page: 108 DAYO AP Version 4.0 TJS LAB ┌───[February 1992]──┐ ┌───────[ DAYO HELP Called by Program: DAYOAP Variable: OPT ]───────┐ │ │ │ │ │ │ │ │ │ Type in anything you wish about this portion of the program! │ │ │ │ The length of this file can be many pages... │ │ │ │ Be sure to press Ctrl W to save any changes/additions you make to this │ │ screen. │ │ │ │ │ │ │ │ │ │ │ │ │ ├────────────────────────────────────────────────────────────────────────────┤ │ Esc (Exit) Ctrl W (Save Changes) F1 (Read Manual) 13/4 │ └────────────────────────────────────────────────────────────────────────────┘ ■ VIEW DOCUMENTATION ONSCREEN To view the documentation for the module you are in, it must first exist in the current directory. Document files are named the same as the module, and have the extension of '.DOC', ie: DAYOINV.DOC, DAYOPOS.DOC, DAYOAP.DOC. Press F1 in the User Defined & Inputted Help Message screen to display the document (user manual). The special keys in this option are displayed in the Help Screen (press F1 again) for this option: ╔══════════════════════════════════════════════════════════════════════════╗ ║ While viewing the document for DAYOAP the keyboard is configured ║ ║ as followed: ║ ║ ║ ║ Esc Exit ║ ║ F5 Find a string. This search is not case sensitive ║ ║ Examples: PAGE: 50 ║ ║ INTRODUCTION ║ ║ REPORTS ║ ║ Home Return to the beginning of the document ║ ║ End Go to the bottom of the document ║ ║ PgUp Page up ║ ║ ║ ║ Any other key moves acts like PgDn (page down) ║ ║ ║ ║ Press any key to continue... ║ ╚══════════════════════════════════════════════════════════════════════════╝ DAYO AP, TJS LAB Page: 109 ■ DATABASE STRUCTURE Database: ACCOUNTS.DBF Field Field name Type Width Dec Start End ───── ────────── ───────── ───── ─── ───── ─── 1 NUMBER Character 2 1 2 2 NAME Character 30 3 32 3 ACCTNUM Character 20 33 52 4 BALANCE Numeric 10 2 53 62 5 ADDR1 Character 30 63 92 6 ADDR2 Character 30 93 122 7 CITY Character 22 123 144 8 STATE Character 2 145 146 9 ZIP Character 10 147 156 10 PHONE Character 14 157 170 11 TYPE Character 3 171 173 12 DATE Date 8 174 181 13 LASTDATE Date 8 182 189 14 LDEPOSIT Numeric 10 2 190 199 15 BEGBAL Numeric 10 2 200 209 16 BEGDATE Date 8 210 217 17 CLASS Character 3 218 220 18 TRANSACT Character 12 221 232 ────────── ───── Total 233 Database: APD.DBF Field Field name Type Width Dec Start End ───── ────────── ───────── ───── ─── ───── ─── 1 JOURNAL Numeric 6 1 6 2 PO Numeric 6 7 12 3 VENDOR Character 10 13 22 4 ITEM Character 12 23 34 5 DESC Character 30 35 64 6 VENDITEM Character 12 65 76 7 QUANTITY Numeric 7 77 83 8 COST Numeric 10 2 84 93 9 DATE Date 8 94 101 10 TYPE Character 3 102 104 11 CLASS Character 3 105 107 12 TRANSACT Character 12 108 119 13 OPEN Logical 1 120 120 14 TAXABLE Logical 1 121 121 15 KEY Numeric 6 122 127 16 RECDATE Date 8 128 135 ────────── ───── Total 136 DAYO AP, TJS LAB Page: 110 Database: APH.DBF Field Field name Type Width Dec Start End ───── ────────── ───────── ───── ─── ───── ─── 1 JOURNAL Numeric 6 1 6 2 PO Numeric 6 7 12 3 VENDOR Character 10 13 22 4 NAME Character 30 23 52 5 ATTN Character 30 53 82 6 ADDR1 Character 30 83 112 7 ADDR2 Character 30 113 142 8 CITY Character 22 143 164 9 STATE Character 2 165 166 10 ZIP Character 10 167 176 11 PHONE Character 14 177 190 12 TYPE Character 3 191 193 13 DATE Date 8 194 201 14 PODATE Date 8 202 209 15 TERMS Character 20 210 229 16 SHIPPER Character 20 230 249 17 SHIPNAME Character 30 250 279 18 SHIPADDR1 Character 30 280 309 19 SHIPADDR2 Character 30 310 339 20 SHIPCITY Character 22 340 361 21 SHIPSTATE Character 2 362 363 22 SHIPZIP Character 10 364 373 23 SHIPPHONE Character 14 374 387 24 BY Character 5 388 392 25 PRINTED Logical 1 393 393 26 KEY Numeric 6 394 399 27 OPEN Logical 1 400 400 28 SUBTOTAL Numeric 10 2 401 410 29 TAXES Numeric 10 2 411 420 30 ADJUST Numeric 10 2 421 430 31 FREIGHT Numeric 10 2 431 440 32 PAID Numeric 10 2 441 450 33 AMOUNT Numeric 10 2 451 460 34 PC Logical 1 461 461 35 CHECKNO Character 12 462 473 36 CLASS Character 3 474 476 37 RECDATE Date 8 477 484 38 PAYDATE Date 8 485 492 39 CONTROL Character 10 493 502 40 WO Numeric 6 503 508 41 TRANSACT Character 12 509 520 42 COMMENT Character 50 521 570 ────────── ───── Total 571 DAYO AP, TJS LAB Page: 110.1 Database: ASSETS.DBF Field Field name Type Width Dec Start End ───── ────────── ───────── ───── ─── ───── ─── 1 ASSET Numeric 6 1 6 2 NAME Character 40 7 46 3 DATE Date 8 47 54 4 VALUE Numeric 10 2 55 64 5 QTY Numeric 7 65 71 6 INCREASE Numeric 10 2 72 81 7 DECREASE Numeric 10 2 82 91 8 CLASS Character 3 92 94 9 DECREASE Numeric 10 2 95 97 ────────── ───── Total 98 DAYO AP, TJS LAB Page: 111 Database: CFORMAT.DBF Field Field name Type Width Dec Start End ───── ────────── ───────── ───── ─── ───── ─── 1 CFORMAT Character 2 1 2 2 NAME Character 30 3 32 3 SETUP Character 50 33 82 4 C_LENGTH Numeric 2 83 84 5 C_WIDTH Numeric 3 85 87 6 V_1ST_LINE Numeric 2 88 89 7 V_END_LINE Numeric 2 90 91 8 V_LCOLUMN Numeric 2 92 93 9 V_RCOLUMN Numeric 3 94 96 10 WORD_ROW Numeric 2 97 98 11 WORD_COL Numeric 2 99 100 12 AMOUNT_ROW Numeric 2 101 102 13 AMOUNT_COL Numeric 3 103 105 14 NAME_ROW Numeric 2 106 107 15 NAME_COL Numeric 2 108 109 16 ADDR_ROW Numeric 2 110 111 17 ADDR_COL Numeric 2 112 113 18 CV_NUM_ROW Numeric 2 114 115 19 CV_NUM_COL Numeric 3 116 118 20 DATE_ROW Numeric 2 119 120 21 DATE_COL Numeric 3 121 123 22 FOR_ROW Numeric 2 124 125 23 FOR_COL Numeric 2 126 127 ────────── ───── Total 128 Database: CHECKS.DBF Field Field name Type Width Dec Start End ───── ────────── ───────── ───── ─── ───── ─── 1 CHECKNO Character 12 1 12 2 ACCTNUM Character 20 13 32 3 NUMBER Character 2 33 34 4 AMOUNT Numeric 10 2 35 44 5 SUBAMOUNT Numeric 10 2 45 54 6 NAME Character 30 55 84 7 WHATFOR Character 40 85 124 8 DATE Date 8 125 132 9 JOURNAL Numeric 6 133 138 10 ACCOUNT Character 10 139 148 11 CV Logical 1 149 149 12 TYPE Character 3 150 152 13 CFORMAT Character 2 153 154 14 CLASS Character 3 155 157 15 TRANSACT Character 12 158 169 16 BY Character 30 170 199 17 CLEARED Logical 1 200 200 18 CLEARDATE Date 8 201 208 ────────── ───── Total 209 DAYO AP, TJS LAB Page: 112 Database: DEPOSITS.DBF Field Field name Type Width Dec Start End ───── ────────── ───────── ───── ─── ───── ─── 1 DEPOSIT Numeric 6 1 6 2 ACCTNUM Character 20 7 26 3 NUMBER Character 2 27 28 4 WHATFOR Character 40 29 68 5 TYPE Character 3 69 71 6 AMOUNT Numeric 10 2 72 81 7 CLASS Character 3 82 84 8 TRANSACT Character 12 85 96 9 DATE Date 8 97 104 10 BY Character 30 105 134 11 CLEARED Logical 1 135 135 12 CLEARDATE Date 8 136 143 ────────── ───── Total 144 Database: EXPENSES.DBF Field Field name Type Width Dec Start End ───── ────────── ───────── ───── ─── ───── ─── 1 EXPENSE Numeric 6 1 6 2 WHATFOR Character 40 7 46 3 TYPE Character 3 47 49 4 AMOUNT Numeric 10 2 50 59 5 TAXES Numeric 10 2 60 69 6 CHECKNO Character 12 70 81 7 ACCTNUM Character 20 82 101 8 NUMBER Character 2 102 103 9 DATE Date 8 104 111 10 SUBTOTAL Numeric 10 2 112 121 11 FREIGHT Numeric 10 2 122 131 12 ADJUST Numeric 10 2 132 141 13 CLASS Character 3 142 144 14 TRANSACT Character 12 145 156 ────────── ───── Total 157 DAYO AP, TJS LAB Page: 113 Database: INV.DBF Field Field name Type Width Dec Start End ───── ────────── ───────── ───── ─── ───── ──── 1 ITEM Character 12 1 12 2 DESC Character 30 13 42 3 DESC2 Character 30 43 72 4 ONHAND Numeric 7 73 79 5 ALLOCATED Numeric 7 80 86 6 ONORDER Numeric 7 87 93 7 BO Numeric 7 94 100 8 SOLDPTD Numeric 7 101 107 9 SOLDYTD Numeric 7 108 114 10 VOLUME Numeric 10 2 115 124 11 VENDITEM Character 12 125 136 12 VENDOR Character 10 137 146 13 DATE Date 8 147 154 14 LASTDATE Date 8 155 162 15 COST Numeric 10 2 163 172 16 AVGCOST Numeric 10 2 173 182 17 REALCOST Numeric 10 2 183 192 18 RETAIL Numeric 10 2 193 202 19 PRICE Numeric 10 2 203 212 20 PRICE1 Numeric 10 2 213 222 21 PRICE2 Numeric 10 2 223 232 22 PRICE3 Numeric 10 2 233 242 23 PRICE4 Numeric 10 2 243 252 24 PRICE5 Numeric 10 2 253 262 25 STOCKLEVEL Numeric 7 263 269 26 MIN Numeric 7 270 276 27 MAX Numeric 7 277 283 28 ABC Character 1 284 284 29 TYPE Character 3 285 287 30 CLASS Character 3 288 290 31 TAXABLE Logical 1 291 291 32 SERIALNO Logical 1 292 292 33 WEIGHT Numeric 8 2 293 300 34 UNIT Character 3 301 303 35 UNITQTY Numeric 7 304 310 36 PACKQTY Character 6 311 316 37 BOM Logical 1 317 317 38 NS Logical 1 318 318 39 TI Logical 1 319 319 40 LOCATION Character 3 320 322 41 BEGIN_QTY Numeric 7 323 329 42 CATEGORY Numeric 1 330 330 ────────── ───── Total 331 DAYO AP, TJS LAB Page: 114 Database: INVADJ.DBF Field Field name Type Width Dec Start End ───── ────────── ───────── ───── ─── ───── ─── 1 ITEM Character 12 1 12 2 VENDITEM Character 12 13 24 3 QTY Numeric 7 25 31 4 COST Numeric 10 2 32 41 5 PRICE Numeric 10 2 42 51 6 RETAIL Numeric 10 2 52 61 7 DOLLARS Numeric 10 2 62 71 8 REASON Character 30 72 101 9 LOC Character 10 102 111 10 BY Character 30 112 141 11 DATE Date 8 142 149 12 CLASS Character 3 150 152 13 TRANSACT Character 12 153 164 ────────── ───── Total 165 Database: POD.DBF Field Field name Type Width Dec Start End ───── ────────── ───────── ───── ─── ───── ─── 1 PO Numeric 6 1 6 2 VENDOR Character 10 7 16 3 ITEM Character 12 17 28 4 DESC Character 30 29 58 5 VENDITEM Character 12 59 70 6 ORDERED Numeric 7 71 77 7 RECEIVED Numeric 7 78 84 8 COST Numeric 10 2 85 94 9 DATE Date 8 95 102 10 ETA Date 8 103 110 11 LASTRECV Date 8 111 118 12 TYPE Character 3 119 121 13 CLASS Character 3 122 124 14 OPEN Logical 1 125 125 15 TAXABLE Logical 1 126 126 ────────── ───── Total 127 DAYO AP, TJS LAB Page: 115 Database: POH.DBF Field Field name Type Width Dec Start End ───── ────────── ───────── ───── ─── ───── ─── 1 PO Numeric 6 1 6 2 VENDOR Character 10 7 16 3 NAME Character 30 17 46 4 ATTN Character 30 47 76 5 ADDR1 Character 30 77 106 6 ADDR2 Character 30 107 136 7 CITY Character 22 137 158 8 STATE Character 2 159 160 9 ZIP Character 10 161 170 10 PHONE Character 14 171 184 11 SHIPNAME Character 30 185 214 12 SHIPADDR1 Character 30 215 244 13 SHIPADDR2 Character 30 245 274 14 SHIPCITY Character 22 275 296 15 SHIPSTATE Character 2 297 298 16 SHIPZIP Character 10 299 308 17 SHIPPHONE Character 14 309 322 18 DATE Date 8 323 330 19 ETA Date 8 331 338 20 SUBTOTAL Numeric 10 2 339 348 21 TAXES Numeric 10 2 349 358 22 ADJUST Numeric 10 2 359 368 23 FREIGHT Numeric 10 2 369 378 24 PAID Numeric 10 2 379 388 25 TERMS Character 20 389 408 26 SHIPPER Character 20 409 428 27 BY Character 30 429 458 28 OPEN Logical 1 459 459 29 PRINTED Logical 1 460 460 30 CLASS Character 3 461 463 31 COMMENT Character 50 464 513 ────────── ───── Total 514 DAYO AP, TJS LAB Page: 116 Database: REC.DBF Field Field name Type Width Dec Start End ───── ────────── ───────── ───── ─── ───── ─── 1 KEY Numeric 6 1 6 2 PO Numeric 6 7 12 3 VENDOR Character 10 13 22 4 ITEM Character 12 23 34 5 DESC Character 30 35 64 6 VENDITEM Character 12 65 76 7 RECEIVED Numeric 7 77 83 8 COST Numeric 10 2 84 93 9 DATE Date 8 94 101 10 BY Character 30 102 131 11 PC Logical 1 132 132 12 COSTADJ Numeric 10 2 133 142 ────────── ───── Total 143 Database: RECHECK.DBF Field Field name Type Width Dec Start End ───── ────────── ───────── ───── ─── ───── ─── 1 RECURRING Numeric 6 1 6 2 NAME Character 30 7 36 3 VE Logical 1 37 37 4 LASTDATE Date 8 38 45 5 SCHEDULE Character 10 46 55 6 PRINT Logical 1 56 56 7 ACCOUNT Character 10 57 66 8 WHATFOR Character 40 67 106 9 TYPE Character 3 107 109 10 AMOUNT Numeric 10 2 110 119 11 SUBTOTAL Numeric 10 2 120 129 12 TAXES Numeric 10 2 130 139 13 FREIGHT Numeric 10 2 140 149 14 ADJUST Numeric 10 2 150 159 15 TOTALPAID Numeric 10 2 160 169 16 ACCTNUM Character 20 170 189 17 NUMBER Character 2 190 191 18 ADDR1 Character 30 192 221 19 ADDR2 Character 30 222 251 20 CITY Character 22 252 273 21 STATE Character 2 274 275 22 ZIP Character 10 276 285 23 PHONE Character 14 286 299 24 DATE Date 8 300 307 25 COMMENT Character 50 308 357 26 CFORMAT Character 2 358 359 ────────── ───── Total 360 DAYO AP, TJS LAB Page: 117 Database: TCHECKS.DBF Field Field name Type Width Dec Start End ───── ────────── ───────── ───── ─── ───── ─── 1 CHECKNO Character 12 1 12 2 ACCTNUM Character 20 13 32 3 NUMBER Character 2 33 34 4 AMOUNT Numeric 10 2 35 44 5 NAME Character 30 45 74 6 WHATFOR Character 40 75 114 7 DATE Date 8 115 122 8 JOURNAL Numeric 6 123 128 9 ACCOUNT Character 10 129 138 10 CV Logical 1 139 139 11 TYPE Character 3 140 142 12 CFORMAT Character 2 143 144 ────────── ───── Total 145 DAYO AP, TJS LAB Page: 118 Database: VENDORS.DBF Field Field name Type Width Dec Start End ───── ────────── ───────── ───── ─── ───── ─── 1 VENDOR Character 10 1 10 2 NAME Character 30 11 40 3 ATTN Character 30 41 70 4 ADDR1 Character 30 71 100 5 ADDR2 Character 30 101 130 6 CITY Character 22 131 152 7 STATE Character 2 153 154 8 ZIP Character 10 155 164 9 PHONE Character 14 165 178 10 SHIPNAME Character 30 179 208 11 SHIPADDR1 Character 30 209 238 12 SHIPADDR2 Character 30 239 268 13 SHIPCITY Character 22 269 290 14 SHIPSTATE Character 2 291 292 15 SHIPZIP Character 10 293 302 16 SHIPPHONE Character 14 303 316 17 TERMS Character 20 317 336 18 SHIPPER Character 20 337 356 19 DATE Date 8 357 364 20 LASTDATE Date 8 365 372 21 FED_ID Character 15 373 387 22 TAXRATE Numeric 6 4 388 393 23 TYPE Character 3 394 396 24 CLASS Character 3 397 399 25 OPEN_PURC Numeric 14 2 400 413 26 RECV_PURC Numeric 14 2 414 427 27 TOT_PURC Numeric 14 2 428 441 28 DUE Numeric 14 2 442 455 29 PAID Numeric 14 2 456 469 30 TOTALPAID Numeric 14 2 470 483 31 FAX Character 14 484 497 32 ACCOUNT Character 12 498 509 33 COMMENT Character 50 510 559 ───────── ───── Total 560 DAYO AP, TJS LAB Page: 119 Database: WAREHOUS.DBF Field Field name Type Width Dec Start End ───── ────────── ───────── ───── ─── ───── ─── 1 ITEM Character 12 1 12 2 LOC1 Numeric 7 13 19 3 SLLOC1 Numeric 7 20 26 4 LOC2 Numeric 7 27 33 5 SLLOC2 Numeric 7 34 40 6 LOC3 Numeric 7 41 47 7 SLLOC3 Numeric 7 48 54 8 LOC4 Numeric 7 55 61 9 SLLOC4 Numeric 7 62 68 10 LOC5 Numeric 7 69 75 11 SLLOC5 Numeric 7 76 82 12 LOC6 Numeric 7 83 89 13 SLLOC6 Numeric 7 90 96 14 LOC7 Numeric 7 97 103 15 SLLOC7 Numeric 7 104 110 ────────── ───── Total 111 Database: WARENAME.DBF Field Field name Type Width Dec Start End ───── ────────── ───────── ───── ─── ───── ─── 1 LOC Character 10 1 10 2 NAME Character 30 11 40 3 COMMENTS Character 40 41 80 ────────── ───── Total 81 DAYO AP, TJS LAB Page: 120 ■ DATA DICTIONARY Field Name Type Len Dec Database Description/Comments ────────── ──── ─── ─── ──────────── ────────────────────────────────── ABC C 1 0 INV.DBF Purchasing code, 'A' means high volume and/or dollar that moves quickly, 'C' means low dollar and moves slowly (pay little attention when reordering these items ACCOUNT C 10 0 RECHECK.DBF Account number (VENDOR, EXPENSE, or CUSTOMER number) CHECKS.DBF TCHECKS.DBF ACCOUTN C 12 0 VENDORS.DBF Number that the vendor assigned to your company ACCTNUM C 20 0 DEPOSITS.DBF Checking Account number assigned by the bank ACCOUNTS.DBF EXPENSES.DBF TCHECKS.DBF CHECKS.DBF RECHECK.DBF ADDR1 C 30 0 ACCOUNTS.DBF Address line 1 POH.DBF RECHECK.DBF APH.DBF VENDORS.DBF ADDR2 C 30 0 RECHECK.DBF Address line 2 ACCOUNTS.DBF POH.DBF VENDORS.DBF APH.DBF ADDR_COL N 2 0 CFORMAT.DBF Starting column of address when printing a check ADDR_ROW N 2 0 CFORMAT.DBF Starting row of address when printing a check ADJUST N 10 2 RECHECK.DBF Adjustment charges POH.DBF APH.DBF ALLOCATED N 7 0 INV.DBF Quantity of items allocated to customer orders AMOUNT N 10 2 DEPOSITS.DBF Amount of Deposit EXPENSES.DBF Amount of Expense APH.DBF Amount of Payable CHECKS.DBF Amount of Check TCHECKS.DBF RECHECK.DBF AMOUNT_COL N 3 0 CFORMAT.DBF Starting column of the check amount when printed on check AMOUNT_ROW N 2 0 CFORMAT.DBF Starting row of the check amount when printed on check ASSET N 6 0 ASSETS.DBF Asset number (you define/set) DAYO AP, TJS LAB Page: 121 Field Name Type Len Dec Database Description/Comments ────────── ──── ─── ─── ──────────── ────────────────────────────────── ATTN C 30 0 POH.DBF Attention/Point of Contact VENDORS.DBF APH.DBF BALANCE N 10 2 ACCOUNTS.DBF Checking account balance BEGBAL N 10 2 ACCOUNTS.DBF Beginning Balance as of BEGDATE BEGDATE D 8 0 ACCOUNTS.DBF Date of beginning balance BEGIN_QTY N 7 0 INV.DBF Use with EOP's Physical Inventory to record the beginning ONHAND for the current period BO N 7 0 INV.DBF Quantity on BackOrder (Placed by your customers, using POS) BOM L 1 0 INV.DBF Flag to designate the item as having a Bill of Material BY C 30 0 CHECKS.DBF Operator Name APH.DBF REC.DBF POH.DBF INVADJ.DBF DEPOSITS.DBF CATEGORY N 1 0 INV.DBF Used to group your inventory into up to 10 groups (0 through 9) CFORMAT C 2 0 CHECKS.DBF Check Printing Format number CFORMAT.DBF TCHECKS.DBF RECHECK.DBF CHECKNO C 12 0 CHECKS.DBF Check number EXPENSES.DBF TCHECKS.DBF APH.DBF CITY C 22 0 ACCOUNTS.DBF Address city RECHECK.DBF POH.DBF APH.DBF VENDORS.DBF CLASS C 3 0 APD.DBF Class of item INV.DBF POD.DBF VENDORS.DBF Class of Vendor ACCOUNTS.DBF Bank Account Class POH.DBF APH.DBF CHECKS.DBF EXPENSES.DBF INVADJ.DBF ASSETS.DBF CLEARDATE D 8 0 DEPOSITS.DBF Date the check/deposit record CHECKS.DBF was check reconciled CLEARED L 1 0 CHECKS.DBF Flag to denote check as being DEPOSITS.DBF cleared or not DAYO AP, TJS LAB Page: 122 Field Name Type Len Dec Database Description/Comments ────────── ──── ─── ─── ──────────── ────────────────────────────────── COMMENT C 50 0 APH.DBF Comments or notes POH.DBF RECHECK.DBF COMMENTS C 40 0 WARENAME.DBF Comments or notes CONTROL C 10 0 APH.DBF User defined entry. Use to record any type of control number, ie: Internal Purchase Order Numbers COST N 10 2 INVADJ.DBF Cost of an item APD.DBF REC.DBF INV.DBF POD.DBF CV L 1 0 CHECKS.DBF Logical flag to denote type of TCHECKS.DBF account, ie: 'CV=.T.' means Customer, else Vendor/Expense CV_NUM_COL N 3 0 CFORMAT.DBF Account type starting column when printing to check CV_NUM_ROW N 2 0 CFORMAT.DBF Account type starting row when printing to check C_LENGTH N 2 0 CFORMAT.DBF Length of the check C_WIDTH N 3 0 CFORMAT.DBF Width of the check DATE D 8 0 TCHECKS.DBF Date of transaction, or date the INV.DBF record was created DEPOSITS.DBF APH.DBF ACCOUNTS.DBF CHECKS.DBF APD.DBF INVADJ.DBF POH.DBF EXPENSES.DBF RECHECK.DBF VENDORS.DBF REC.DBF POD.DBF ASSETS.DBF DATE_COL N 3 0 CFORMAT.DBF Starting column of the check date when printing DATE_ROW N 2 0 CFORMAT.DBF Starting row of the check date when printing DEPOSIT N 6 0 DEPOSITS.DBF Deposit number (a control number) DECREASE N 10 2 ASSETS.DBF Not used DESC C 30 0 POD.DBF Description of item REC.DBF APD.DBF INV.DBF DESC2 C 30 0 INV.DBF 2nd line of item description DOLLARS N 10 2 INVADJ.DBF Cost variance DUE N 10 2 VENDORS.DBF Amount still due (balance due to Vendor) DAYO AP, TJS LAB Page: 123 Field Name Type Len Dec Database Description/Comments ────────── ──── ─── ─── ──────────── ────────────────────────────────── ETA D 8 0 POH.DBF Estimated Time (date) of Arrival POD.DBF APH.DBF EXPENSE N 6 0 EXPENSES.DBF Expense number (a control number) FAX C 14 0 VENDORS.DBF Fax number FED_ID C 15 0 VENDORS.DBF Federal Identification Number (for tax purposes, ie 1099 forms) FOR_COL N 2 0 CFORMAT.DBF Starting column for the printing of the check reason/for FOR_ROW N 2 0 CFORMAT.DBF Starting row for the printing of the check reason/for FREIGHT N 10 2 POH.DBF Freight charges APH.DBF RECHECK.DBF INCREASE N 10 2 ASSETS.DBF Not used ITEM C 12 0 INV.DBF Item/Product/Part Number/Code APD.DBF REC.DBF INVADJ.DBF WAREHOUS.DBF POD.DBF JOURNAL N 6 0 APD.DBF Journal number (a control number) CHECKS.DBF APH.DBF TCHECKS.DBF KEY N 6 0 APD.DBF Key/Receiver number (a control REC.DBF number) APH.DBF LASTDATE D 8 0 INV.DBF Date last accessed RECHECK.DBF ACCOUNTS.DBF VENDORS.DBF LASTRECV D 8 0 POD.DBF Date of last receipt LDEPOSIT N 10 2 ACCOUNTS.DBF Date of last deposit into checking account LOC C 10 0 WARENAME.DBF Warehouse/Location name, ie: LOC1, LOC2, LOC3 ... LOC1 N 7 0 WAREHOUS.DBF Warehouse/Location #1 LOC2 N 7 0 WAREHOUS.DBF Warehouse/Location #2 LOC3 N 7 0 WAREHOUS.DBF Warehouse/Location #3 LOC4 N 7 0 WAREHOUS.DBF Warehouse/Location #4 LOC5 N 7 0 WAREHOUS.DBF Warehouse/Location #5 LOC6 N 7 0 WAREHOUS.DBF Warehouse/Location #6 LOC7 N 7 0 WAREHOUS.DBF Warehouse/Location #7 LOCATION C 3 0 INV.DBF Location 'Bin' code MAX N 7 0 INV.DBF Maximum value to stock/reorder MIN N 7 0 INV.DBF Minimum value to stock/reorder NAME C 40 0 ASSETS.DBF Name of asset DAYO AP, TJS LAB Page: 125 Field Name Type Len Dec Database Description/Comments ────────── ──── ─── ─── ──────────── ────────────────────────────────── NAME C 30 0 WARENAME.DBF Literal name of a warehouse, ie: OBSOLETE, INTERNAL USE ... CHECKS.DBF Payee TCHECKS.DBF CFORMAT.DBF Check style APH.DBF Vendor name RECHECK.DBF Payee ACCOUNTS.DBF Bank name POH.DBF Vendor name VENDORS.DBF NAME_COL N 2 0 CFORMAT.DBF Starting column when printing the Payee name onto a check NAME_ROW N 2 0 CFORMAT.DBF Starting row when printing the Payee name onto a check NS L 1 0 INV.DBF Flag to denote item as being a non-standard item NUMBER C 2 0 DEPOSITS.DBF Checking account sequence number, ACCOUNTS.DBF ie, the first account would be '1' EXPENSES.DBF RECHECK.DBF CHECKS.DBF TCHECKS.DBF ONHAND N 7 0 INV.DBF Main warehouse quantity ONORDER N 7 0 INV.DBF Quantity on order with a Vendor OPEN L 1 0 APD.DBF Logical flag used when posting POD.DBF APH.DBF POH.DBF OPEN_PURC N 10 2 VENDORS.DBF Amount of Open Purchase Orders ORDERED N 7 0 POD.DBF Total quantity originally ordered PACKQTY C 6 0 INV.DBF Description of packing quantity PAID N 10 2 POH.DBF Amount paid on this PO VENDORS.DBF Amount paid to a Vendor PAYDATE D 8 0 APH.DBF Date payable is to be paid PC L 1 0 APH.DBF Purchase Clearing flag REC.DBF PHONE C 14 0 ACCOUNTS.DBF Telephone number POH.DBF RECHECK.DBF APH.DBF VENDORS.DBF PO N 6 0 APH.DBF Purchase Order number POD.DBF POH.DBF APD.DBF REC.DBF PODATE D 8 0 APH.DBF Purchase Order date DAYO AP, TJS LAB Page: 126 Field Name Type Len Dec Database Description/Comments ────────── ──── ─── ─── ──────────── ────────────────────────────────── PRICE N 10 2 INVADJ.DBF Price of an item INV.DBF PRICE1 N 10 2 INV.DBF Multiple price field PRICE2 N 10 2 INV.DBF " PRICE3 N 10 2 INV.DBF " PRICE4 N 10 2 INV.DBF " PRICE5 N 10 2 INV.DBF " PRINT L 1 0 RECHECK.DBF Logical flag to mark a Recurring check to be printed PRINTED L 1 0 POH.DBF Logical flag to show if the APH.DBF Purchase Order has been printed QTY N 7 0 INVADJ.DBF Inventory adjustment quantity ASSETS.DBF QUANTITY N 7 0 APD.DBF Quantity received/AP detail quantity REASON C 30 0 INVADJ.DBF Reason for the Inventory Adjustment RECDATE D 8 0 APD.DBF Date received APH.DBF RECEIVED N 7 0 REC.DBF Quantity received POD.DBF RECURRING N 6 0 RECHECK.DBF Recurring check number (a control number) RECURRING L 1 0 APH.DBF Flag to denote payable as being recurring RECURRDAYS N 3 0 APH.DBF Number of days until next paydate RECV_PURC N 10 2 VENDORS.DBF Amount of Vendors product RETAIL N 10 2 INVADJ.DBF Retail/List price for an item INV.DBF SCHEDULE C 10 0 RECHECK.DBF Recurring schedule code SERIALNO L 1 0 INV.DBF Logical flag to denote that this item has a serial number that requires recording when invoicing SETUP C 50 0 CFORMAT.DBF Printer setup string that is printed at start of checks DAYO AP, TJS LAB Page: 125 Field Name Type Len Dec Database Description/Comments ────────── ──── ─── ─── ──────────── ────────────────────────────────── SHIPPER C 20 0 POH.DBF Shipper/Method of shipment APH.DBF VENDORS.DBF SHIPNAME C 30 0 POH.DBF Ship to Name and Address APH.DBF SHIPADDR1 C 30 0 POH.DBF APH.DBF SHIPADDR2 C 30 0 POH.DBF APH.DBF SHIPCITY C 22 0 POH.DBF APH.DBF SHIPSTATE C 2 0 POH.DBF APH.DBF SHIPZIP C 10 0 POH.DBF APH.DBF SHIPPHONE C 14 0 POH.DBF APH.DBF SLLOC1 N 7 0 WAREHOUS.DBF Stocking Level for warehouse #1 SLLOC2 N 7 0 WAREHOUS.DBF Stocking Level for warehouse #2 SLLOC3 N 7 0 WAREHOUS.DBF Stocking Level for warehouse #3 SLLOC4 N 7 0 WAREHOUS.DBF Stocking Level for warehouse #4 SLLOC5 N 7 0 WAREHOUS.DBF Stocking Level for warehouse #5 SLLOC6 N 7 0 WAREHOUS.DBF Stocking Level for warehouse #6 SLLOC7 N 7 0 WAREHOUS.DBF Stocking Level for warehouse #7 SOLDPTD N 7 0 INV.DBF Quantity sold Period to Date SOLDYTD N 7 0 INV.DBF Quantity sold Year to Date STATE C 2 0 APH.DBF Address state code, ie: FL, CA... VENDORS.DBF POH.DBF RECHECK.DBF ACCOUNTS.DBF STOCKLEVEL N 7 0 INV.DBF Stocking Level for the main warehouse SUBAMOUNT N 10 2 CHECKS.DBF Not used SUBTOTAL N 10 2 RECHECK.DBF Check subtotal POH.DBF Purchase Order subtotal APH.DBF Payable subtotal TAXABLE L 1 0 INV.DBF Taxable flag POD.DBF APD.DBF TAXES N 10 2 APH.DBF Tax subtotal POH.DBF EXPENSES.DBF RECHECK.DBF TAXRATE N 5 3 VENDORS.DBF Tax rate TERMS C 20 0 POH.DBF Terms, ie: NET 30, CASH, COD VENDORS.DBF APH.DBF TI L 1 0 INV.DBF Flag to denote item as being a time/labor item TOTALPAID N 10 2 VENDORS.DBF Total amount paid to this Vendor RECHECK.DBF Total amount paid to this Recurring check Payee DAYO AP, TJS LAB Page: 126 Field Name Type Len Dec Database Description/Comments ────────── ──── ─── ─── ──────────── ────────────────────────────────── TOT_PURC N 10 2 VENDORS.DBF Total amount of purchases from the Vendor TRANSACT C 12 APH.DBF GL Transaction Number APD.DBF VENDORS.DBF INVADJ.DBF CHECKS.DBF ACCOUNTS.DBF DEPOSITS.DBF EXPENSES.DBF TYPE C 3 0 APH.DBF Type, user defined EXPENSES.DBF DEPOSITS.DBF INV.DBF ACCOUNTS.DBF TCHECKS.DBF APD.DBF POD.DBF RECHECK.DBF CHECKS.DBF VENDORS.DBF ASSETS.DBF UNIT C 3 0 INV.DBF Unit of issue, ie: EA, BOX, KIT UNITQTY N 7 0 INV.DBF Used in purchasing. The order qty is divided by the value in this field when creating a purchase order VALUE N 10 2 ASSETS.DBF Value of 1 asset VE L 1 0 RECHECK.DBF Logical flag to denote whether the Recurring check is for a Vendor or Expense VENDITEM C 12 0 REC.DBF Vendor or Manufacturer product APD.DBF number POD.DBF INV.DBF INVADJ.DBF VENDOR C 10 0 INV.DBF Vendor number APH.DBF VENDORS.DBF REC.DBF POH.DBF APD.DBF POD.DBF V_1ST_LINE N 2 0 CFORMAT.DBF Starting line of Check Voucher (enter '0' for Check only) V_END_LINE N 2 0 CFORMAT.DBF Ending line of Check Voucher (enter '0' for Check only) V_LCOLUMN N 2 0 CFORMAT.DBF Starting column (left side) of Voucher (enter '0' for Check only) DAYO AP, TJS LAB Page: 127 Field Name Type Len Dec Database Description/Comments ────────── ──── ─── ─── ──────────── ────────────────────────────────── V_RCOLUMN N 3 0 CFORMAT.DBF Ending column (right side) of Voucher (enter '0' for Check only) VOLUME N 10 2 INV.DBF Use in special reports to record the number of items sold within the current period WEIGHT N 8 2 INV.DBF Weight of an item WHATFOR C 40 0 CHECKS.DBF Reason for the Check DEPOSITS.DBF Reason/Comment for the Deposit TCHECKS.DBF Reason for the Check RECHECK.DBF Reason/Expense name EXPENSES.DBF WO N 6 0 APH.DBF Work Order number WORD_COL N 2 0 CFORMAT.DBF Starting column for the printing of the dollar amount onto the Check WORD_ROW N 2 0 CFORMAT.DBF Starting row for the printing of the dollar amount onto the Check ZIP C 10 0 ACCOUNTS.DBF Address Zip code POH.DBF VENDORS.DBF RECHECK.DBF APH.DBF DAYO AP, TJS LAB Page: 128 ■ DAYO AP MAINTENANCE & QUIRKS - If you are on a multiuser network, you must 'flag' (change file attributes) of all files to make them sharable, readable and writable. Note that the command/program 'flag' may be called by a different name on your network. ie: E:\>FLAG *.NTX SRW or just to be safe, go ahead and flag all files in the DAYO directory: E:\>FLAG *.* SRW - Backups of your data and configuration files should take place daily! You have no doubt heard many 'scare' stories about losing data. They are all true! The key files that need to be backed up all have the extension of .DBF, .DBT, and .CFG. The .DBF files are your databases. The .DBT files are notes/memos. The .CFG file(s) contain your configuration information (as seen in the Configuration module). - If you are on a network, it is NOT recommended that you use dBase III+ with the databases. It may write an end of file marker not always recognized by DAYO. Appending additional records to the database after this point often leads/creates a 'bad record' in the database. - If you must use dBase (tm) with DAYO AP, and you are on a PC based network/LAN, be sure to SET EXCLUSIVE OFF before you open ANY databases. This will allow the opened databases to be shared, and more importantly, prevent a user (or all users!) from 'crashing'! - If the SIMPLE EDITOR tends to 'hang' your CPU, even on small files, then do not use it... Hope to fix this 'feature' with the next upgrade... DAYO AP, TJS LAB Page: 129 ■ TJS 'Computer' LAB TJS LAB is an association of programmers and technicians that produce customized, multiuser software for the PC based network (ie: Novell and others). Our specialties include Inventory Control, PC Communications/EDI, Management, Reports (standard and graphic), Data Conversions, and Accounting (A/R, A/P). A unique feature of TJS LAB is that our software is by default, multiuser. 'Standalone' applications are the exception! All our applications are written in Clipper, Basic, or C (preferably Basic or Clipper). We will license all our application source codes. We produce applications that work, are easy to use, and are inexpensive! Want a change? Want an enhancement! Want a completely new product/application? Want to make your idea a reality? Custom/contract programming, by TJS LAB, and our associates is available. Standard rate is $50.00 per hour (our sites). Guaranteed quality and timely work is our number one policy. We make program enhancements/changes/fixes at our location(s), but can/do make 'house calls' via special software and a modem. Write us at: TJS LAB PO Box 585366 Orlando, Florida 32858-5366 Or call us (8:00 am - 11:00 pm): (407) 291-3960 * Note that TJS LAB, nor any of the associates accept/take any support calls for unregistered products.